/*
 Navicat Premium Data Transfer

 Source Server         : 家旁养车
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : 47.107.82.90:3306
 Source Schema         : familycarmaintenance

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 29/05/2019 14:09:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fcm_admin
-- ----------------------------
DROP TABLE IF EXISTS `fcm_admin`;
CREATE TABLE `fcm_admin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
  `account` varchar(45) NOT NULL COMMENT '管理员账号',
  `password` varchar(255) NOT NULL COMMENT '管理员密码',
  `ip` varchar(255) DEFAULT '0.0.0.0' COMMENT 'ip白名单（多个ip用 符号'' ; ''  隔开 ）',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '管理员类型（0、超级管理员 1、普通管理员）',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `login_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '最近一次登录时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unx_account` (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员信息表';

-- ----------------------------
-- Table structure for fcm_admin_operation
-- ----------------------------
DROP TABLE IF EXISTS `fcm_admin_operation`;
CREATE TABLE `fcm_admin_operation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '管理员操作日志表的唯一标识',
  `admin_id` bigint(20) NOT NULL COMMENT '管理员id',
  `operation_id` bigint(20) NOT NULL COMMENT '操作表id',
  `ip` varchar(45) NOT NULL DEFAULT '0.0.0.0' COMMENT '登录ip',
  `description` varchar(255) NOT NULL COMMENT '描述',
  `create_time` datetime NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员操作日志表';

-- ----------------------------
-- Table structure for fcm_areas
-- ----------------------------
DROP TABLE IF EXISTS `fcm_areas`;
CREATE TABLE `fcm_areas` (
  `area_id` char(6) CHARACTER SET utf8 NOT NULL COMMENT '区县编码',
  `city_id` char(6) CHARACTER SET utf8 NOT NULL COMMENT '所属城市编码',
  `area` varchar(40) CHARACTER SET utf8 NOT NULL COMMENT '区县名称',
  PRIMARY KEY (`area_id`),
  UNIQUE KEY `unx_city_id_and_area_id` (`city_id`,`area_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='区县信息表';

-- ----------------------------
-- Records of fcm_areas
-- ----------------------------
BEGIN;
INSERT INTO `fcm_areas` VALUES ('110101', '110100', '东城区');
INSERT INTO `fcm_areas` VALUES ('110102', '110100', '西城区');
INSERT INTO `fcm_areas` VALUES ('110103', '110100', '崇文区');
INSERT INTO `fcm_areas` VALUES ('110104', '110100', '宣武区');
INSERT INTO `fcm_areas` VALUES ('110105', '110100', '朝阳区');
INSERT INTO `fcm_areas` VALUES ('110106', '110100', '丰台区');
INSERT INTO `fcm_areas` VALUES ('110107', '110100', '石景山区');
INSERT INTO `fcm_areas` VALUES ('110108', '110100', '海淀区');
INSERT INTO `fcm_areas` VALUES ('110109', '110100', '门头沟区');
INSERT INTO `fcm_areas` VALUES ('110111', '110100', '房山区');
INSERT INTO `fcm_areas` VALUES ('110112', '110100', '通州区');
INSERT INTO `fcm_areas` VALUES ('110113', '110100', '顺义区');
INSERT INTO `fcm_areas` VALUES ('110114', '110100', '昌平区');
INSERT INTO `fcm_areas` VALUES ('110115', '110100', '大兴区');
INSERT INTO `fcm_areas` VALUES ('110116', '110100', '怀柔区');
INSERT INTO `fcm_areas` VALUES ('110117', '110100', '平谷区');
INSERT INTO `fcm_areas` VALUES ('110228', '110100', '密云县');
INSERT INTO `fcm_areas` VALUES ('110229', '110100', '延庆县');
INSERT INTO `fcm_areas` VALUES ('120101', '120100', '和平区');
INSERT INTO `fcm_areas` VALUES ('120102', '120100', '河东区');
INSERT INTO `fcm_areas` VALUES ('120103', '120100', '河西区');
INSERT INTO `fcm_areas` VALUES ('120104', '120100', '南开区');
INSERT INTO `fcm_areas` VALUES ('120105', '120100', '河北区');
INSERT INTO `fcm_areas` VALUES ('120106', '120100', '红桥区');
INSERT INTO `fcm_areas` VALUES ('120107', '120100', '塘沽区');
INSERT INTO `fcm_areas` VALUES ('120108', '120100', '汉沽区');
INSERT INTO `fcm_areas` VALUES ('120109', '120100', '大港区');
INSERT INTO `fcm_areas` VALUES ('120110', '120100', '东丽区');
INSERT INTO `fcm_areas` VALUES ('120111', '120100', '西青区');
INSERT INTO `fcm_areas` VALUES ('120112', '120100', '津南区');
INSERT INTO `fcm_areas` VALUES ('120113', '120100', '北辰区');
INSERT INTO `fcm_areas` VALUES ('120114', '120100', '武清区');
INSERT INTO `fcm_areas` VALUES ('120115', '120100', '宝坻区');
INSERT INTO `fcm_areas` VALUES ('120221', '120100', '宁河县');
INSERT INTO `fcm_areas` VALUES ('120223', '120100', '静海县');
INSERT INTO `fcm_areas` VALUES ('120225', '120100', '蓟　县');
INSERT INTO `fcm_areas` VALUES ('130101', '130100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130102', '130100', '长安区');
INSERT INTO `fcm_areas` VALUES ('130103', '130100', '桥东区');
INSERT INTO `fcm_areas` VALUES ('130104', '130100', '桥西区');
INSERT INTO `fcm_areas` VALUES ('130105', '130100', '新华区');
INSERT INTO `fcm_areas` VALUES ('130107', '130100', '井陉矿区');
INSERT INTO `fcm_areas` VALUES ('130108', '130100', '裕华区');
INSERT INTO `fcm_areas` VALUES ('130121', '130100', '井陉县');
INSERT INTO `fcm_areas` VALUES ('130123', '130100', '正定县');
INSERT INTO `fcm_areas` VALUES ('130124', '130100', '栾城县');
INSERT INTO `fcm_areas` VALUES ('130125', '130100', '行唐县');
INSERT INTO `fcm_areas` VALUES ('130126', '130100', '灵寿县');
INSERT INTO `fcm_areas` VALUES ('130127', '130100', '高邑县');
INSERT INTO `fcm_areas` VALUES ('130128', '130100', '深泽县');
INSERT INTO `fcm_areas` VALUES ('130129', '130100', '赞皇县');
INSERT INTO `fcm_areas` VALUES ('130130', '130100', '无极县');
INSERT INTO `fcm_areas` VALUES ('130131', '130100', '平山县');
INSERT INTO `fcm_areas` VALUES ('130132', '130100', '元氏县');
INSERT INTO `fcm_areas` VALUES ('130133', '130100', '赵　县');
INSERT INTO `fcm_areas` VALUES ('130181', '130100', '辛集市');
INSERT INTO `fcm_areas` VALUES ('130182', '130100', '藁城市');
INSERT INTO `fcm_areas` VALUES ('130183', '130100', '晋州市');
INSERT INTO `fcm_areas` VALUES ('130184', '130100', '新乐市');
INSERT INTO `fcm_areas` VALUES ('130185', '130100', '鹿泉市');
INSERT INTO `fcm_areas` VALUES ('130201', '130200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130202', '130200', '路南区');
INSERT INTO `fcm_areas` VALUES ('130203', '130200', '路北区');
INSERT INTO `fcm_areas` VALUES ('130204', '130200', '古冶区');
INSERT INTO `fcm_areas` VALUES ('130205', '130200', '开平区');
INSERT INTO `fcm_areas` VALUES ('130207', '130200', '丰南区');
INSERT INTO `fcm_areas` VALUES ('130208', '130200', '丰润区');
INSERT INTO `fcm_areas` VALUES ('130223', '130200', '滦　县');
INSERT INTO `fcm_areas` VALUES ('130224', '130200', '滦南县');
INSERT INTO `fcm_areas` VALUES ('130225', '130200', '乐亭县');
INSERT INTO `fcm_areas` VALUES ('130227', '130200', '迁西县');
INSERT INTO `fcm_areas` VALUES ('130229', '130200', '玉田县');
INSERT INTO `fcm_areas` VALUES ('130230', '130200', '唐海县');
INSERT INTO `fcm_areas` VALUES ('130281', '130200', '遵化市');
INSERT INTO `fcm_areas` VALUES ('130283', '130200', '迁安市');
INSERT INTO `fcm_areas` VALUES ('130301', '130300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130302', '130300', '海港区');
INSERT INTO `fcm_areas` VALUES ('130303', '130300', '山海关区');
INSERT INTO `fcm_areas` VALUES ('130304', '130300', '北戴河区');
INSERT INTO `fcm_areas` VALUES ('130321', '130300', '青龙满族自治县');
INSERT INTO `fcm_areas` VALUES ('130322', '130300', '昌黎县');
INSERT INTO `fcm_areas` VALUES ('130323', '130300', '抚宁县');
INSERT INTO `fcm_areas` VALUES ('130324', '130300', '卢龙县');
INSERT INTO `fcm_areas` VALUES ('130401', '130400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130402', '130400', '邯山区');
INSERT INTO `fcm_areas` VALUES ('130403', '130400', '丛台区');
INSERT INTO `fcm_areas` VALUES ('130404', '130400', '复兴区');
INSERT INTO `fcm_areas` VALUES ('130406', '130400', '峰峰矿区');
INSERT INTO `fcm_areas` VALUES ('130421', '130400', '邯郸县');
INSERT INTO `fcm_areas` VALUES ('130423', '130400', '临漳县');
INSERT INTO `fcm_areas` VALUES ('130424', '130400', '成安县');
INSERT INTO `fcm_areas` VALUES ('130425', '130400', '大名县');
INSERT INTO `fcm_areas` VALUES ('130426', '130400', '涉　县');
INSERT INTO `fcm_areas` VALUES ('130427', '130400', '磁　县');
INSERT INTO `fcm_areas` VALUES ('130428', '130400', '肥乡县');
INSERT INTO `fcm_areas` VALUES ('130429', '130400', '永年县');
INSERT INTO `fcm_areas` VALUES ('130430', '130400', '邱　县');
INSERT INTO `fcm_areas` VALUES ('130431', '130400', '鸡泽县');
INSERT INTO `fcm_areas` VALUES ('130432', '130400', '广平县');
INSERT INTO `fcm_areas` VALUES ('130433', '130400', '馆陶县');
INSERT INTO `fcm_areas` VALUES ('130434', '130400', '魏　县');
INSERT INTO `fcm_areas` VALUES ('130435', '130400', '曲周县');
INSERT INTO `fcm_areas` VALUES ('130481', '130400', '武安市');
INSERT INTO `fcm_areas` VALUES ('130501', '130500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130502', '130500', '桥东区');
INSERT INTO `fcm_areas` VALUES ('130503', '130500', '桥西区');
INSERT INTO `fcm_areas` VALUES ('130521', '130500', '邢台县');
INSERT INTO `fcm_areas` VALUES ('130522', '130500', '临城县');
INSERT INTO `fcm_areas` VALUES ('130523', '130500', '内丘县');
INSERT INTO `fcm_areas` VALUES ('130524', '130500', '柏乡县');
INSERT INTO `fcm_areas` VALUES ('130525', '130500', '隆尧县');
INSERT INTO `fcm_areas` VALUES ('130526', '130500', '任　县');
INSERT INTO `fcm_areas` VALUES ('130527', '130500', '南和县');
INSERT INTO `fcm_areas` VALUES ('130528', '130500', '宁晋县');
INSERT INTO `fcm_areas` VALUES ('130529', '130500', '巨鹿县');
INSERT INTO `fcm_areas` VALUES ('130530', '130500', '新河县');
INSERT INTO `fcm_areas` VALUES ('130531', '130500', '广宗县');
INSERT INTO `fcm_areas` VALUES ('130532', '130500', '平乡县');
INSERT INTO `fcm_areas` VALUES ('130533', '130500', '威　县');
INSERT INTO `fcm_areas` VALUES ('130534', '130500', '清河县');
INSERT INTO `fcm_areas` VALUES ('130535', '130500', '临西县');
INSERT INTO `fcm_areas` VALUES ('130581', '130500', '南宫市');
INSERT INTO `fcm_areas` VALUES ('130582', '130500', '沙河市');
INSERT INTO `fcm_areas` VALUES ('130601', '130600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130602', '130600', '新市区');
INSERT INTO `fcm_areas` VALUES ('130603', '130600', '北市区');
INSERT INTO `fcm_areas` VALUES ('130604', '130600', '南市区');
INSERT INTO `fcm_areas` VALUES ('130621', '130600', '满城县');
INSERT INTO `fcm_areas` VALUES ('130622', '130600', '清苑县');
INSERT INTO `fcm_areas` VALUES ('130623', '130600', '涞水县');
INSERT INTO `fcm_areas` VALUES ('130624', '130600', '阜平县');
INSERT INTO `fcm_areas` VALUES ('130625', '130600', '徐水县');
INSERT INTO `fcm_areas` VALUES ('130626', '130600', '定兴县');
INSERT INTO `fcm_areas` VALUES ('130627', '130600', '唐　县');
INSERT INTO `fcm_areas` VALUES ('130628', '130600', '高阳县');
INSERT INTO `fcm_areas` VALUES ('130629', '130600', '容城县');
INSERT INTO `fcm_areas` VALUES ('130630', '130600', '涞源县');
INSERT INTO `fcm_areas` VALUES ('130631', '130600', '望都县');
INSERT INTO `fcm_areas` VALUES ('130632', '130600', '安新县');
INSERT INTO `fcm_areas` VALUES ('130633', '130600', '易　县');
INSERT INTO `fcm_areas` VALUES ('130634', '130600', '曲阳县');
INSERT INTO `fcm_areas` VALUES ('130635', '130600', '蠡　县');
INSERT INTO `fcm_areas` VALUES ('130636', '130600', '顺平县');
INSERT INTO `fcm_areas` VALUES ('130637', '130600', '博野县');
INSERT INTO `fcm_areas` VALUES ('130638', '130600', '雄　县');
INSERT INTO `fcm_areas` VALUES ('130681', '130600', '涿州市');
INSERT INTO `fcm_areas` VALUES ('130682', '130600', '定州市');
INSERT INTO `fcm_areas` VALUES ('130683', '130600', '安国市');
INSERT INTO `fcm_areas` VALUES ('130684', '130600', '高碑店市');
INSERT INTO `fcm_areas` VALUES ('130701', '130700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130702', '130700', '桥东区');
INSERT INTO `fcm_areas` VALUES ('130703', '130700', '桥西区');
INSERT INTO `fcm_areas` VALUES ('130705', '130700', '宣化区');
INSERT INTO `fcm_areas` VALUES ('130706', '130700', '下花园区');
INSERT INTO `fcm_areas` VALUES ('130721', '130700', '宣化县');
INSERT INTO `fcm_areas` VALUES ('130722', '130700', '张北县');
INSERT INTO `fcm_areas` VALUES ('130723', '130700', '康保县');
INSERT INTO `fcm_areas` VALUES ('130724', '130700', '沽源县');
INSERT INTO `fcm_areas` VALUES ('130725', '130700', '尚义县');
INSERT INTO `fcm_areas` VALUES ('130726', '130700', '蔚　县');
INSERT INTO `fcm_areas` VALUES ('130727', '130700', '阳原县');
INSERT INTO `fcm_areas` VALUES ('130728', '130700', '怀安县');
INSERT INTO `fcm_areas` VALUES ('130729', '130700', '万全县');
INSERT INTO `fcm_areas` VALUES ('130730', '130700', '怀来县');
INSERT INTO `fcm_areas` VALUES ('130731', '130700', '涿鹿县');
INSERT INTO `fcm_areas` VALUES ('130732', '130700', '赤城县');
INSERT INTO `fcm_areas` VALUES ('130733', '130700', '崇礼县');
INSERT INTO `fcm_areas` VALUES ('130801', '130800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130802', '130800', '双桥区');
INSERT INTO `fcm_areas` VALUES ('130803', '130800', '双滦区');
INSERT INTO `fcm_areas` VALUES ('130804', '130800', '鹰手营子矿区');
INSERT INTO `fcm_areas` VALUES ('130821', '130800', '承德县');
INSERT INTO `fcm_areas` VALUES ('130822', '130800', '兴隆县');
INSERT INTO `fcm_areas` VALUES ('130823', '130800', '平泉县');
INSERT INTO `fcm_areas` VALUES ('130824', '130800', '滦平县');
INSERT INTO `fcm_areas` VALUES ('130825', '130800', '隆化县');
INSERT INTO `fcm_areas` VALUES ('130826', '130800', '丰宁满族自治县');
INSERT INTO `fcm_areas` VALUES ('130827', '130800', '宽城满族自治县');
INSERT INTO `fcm_areas` VALUES ('130828', '130800', '围场满族蒙古族自治县');
INSERT INTO `fcm_areas` VALUES ('130901', '130900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('130902', '130900', '新华区');
INSERT INTO `fcm_areas` VALUES ('130903', '130900', '运河区');
INSERT INTO `fcm_areas` VALUES ('130921', '130900', '沧　县');
INSERT INTO `fcm_areas` VALUES ('130922', '130900', '青　县');
INSERT INTO `fcm_areas` VALUES ('130923', '130900', '东光县');
INSERT INTO `fcm_areas` VALUES ('130924', '130900', '海兴县');
INSERT INTO `fcm_areas` VALUES ('130925', '130900', '盐山县');
INSERT INTO `fcm_areas` VALUES ('130926', '130900', '肃宁县');
INSERT INTO `fcm_areas` VALUES ('130927', '130900', '南皮县');
INSERT INTO `fcm_areas` VALUES ('130928', '130900', '吴桥县');
INSERT INTO `fcm_areas` VALUES ('130929', '130900', '献　县');
INSERT INTO `fcm_areas` VALUES ('130930', '130900', '孟村回族自治县');
INSERT INTO `fcm_areas` VALUES ('130981', '130900', '泊头市');
INSERT INTO `fcm_areas` VALUES ('130982', '130900', '任丘市');
INSERT INTO `fcm_areas` VALUES ('130983', '130900', '黄骅市');
INSERT INTO `fcm_areas` VALUES ('130984', '130900', '河间市');
INSERT INTO `fcm_areas` VALUES ('131001', '131000', '市辖区');
INSERT INTO `fcm_areas` VALUES ('131002', '131000', '安次区');
INSERT INTO `fcm_areas` VALUES ('131003', '131000', '广阳区');
INSERT INTO `fcm_areas` VALUES ('131022', '131000', '固安县');
INSERT INTO `fcm_areas` VALUES ('131023', '131000', '永清县');
INSERT INTO `fcm_areas` VALUES ('131024', '131000', '香河县');
INSERT INTO `fcm_areas` VALUES ('131025', '131000', '大城县');
INSERT INTO `fcm_areas` VALUES ('131026', '131000', '文安县');
INSERT INTO `fcm_areas` VALUES ('131028', '131000', '大厂回族自治县');
INSERT INTO `fcm_areas` VALUES ('131081', '131000', '霸州市');
INSERT INTO `fcm_areas` VALUES ('131082', '131000', '三河市');
INSERT INTO `fcm_areas` VALUES ('131101', '131100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('131102', '131100', '桃城区');
INSERT INTO `fcm_areas` VALUES ('131121', '131100', '枣强县');
INSERT INTO `fcm_areas` VALUES ('131122', '131100', '武邑县');
INSERT INTO `fcm_areas` VALUES ('131123', '131100', '武强县');
INSERT INTO `fcm_areas` VALUES ('131124', '131100', '饶阳县');
INSERT INTO `fcm_areas` VALUES ('131125', '131100', '安平县');
INSERT INTO `fcm_areas` VALUES ('131126', '131100', '故城县');
INSERT INTO `fcm_areas` VALUES ('131127', '131100', '景　县');
INSERT INTO `fcm_areas` VALUES ('131128', '131100', '阜城县');
INSERT INTO `fcm_areas` VALUES ('131181', '131100', '冀州市');
INSERT INTO `fcm_areas` VALUES ('131182', '131100', '深州市');
INSERT INTO `fcm_areas` VALUES ('140101', '140100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140105', '140100', '小店区');
INSERT INTO `fcm_areas` VALUES ('140106', '140100', '迎泽区');
INSERT INTO `fcm_areas` VALUES ('140107', '140100', '杏花岭区');
INSERT INTO `fcm_areas` VALUES ('140108', '140100', '尖草坪区');
INSERT INTO `fcm_areas` VALUES ('140109', '140100', '万柏林区');
INSERT INTO `fcm_areas` VALUES ('140110', '140100', '晋源区');
INSERT INTO `fcm_areas` VALUES ('140121', '140100', '清徐县');
INSERT INTO `fcm_areas` VALUES ('140122', '140100', '阳曲县');
INSERT INTO `fcm_areas` VALUES ('140123', '140100', '娄烦县');
INSERT INTO `fcm_areas` VALUES ('140181', '140100', '古交市');
INSERT INTO `fcm_areas` VALUES ('140201', '140200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140202', '140200', '城　区');
INSERT INTO `fcm_areas` VALUES ('140203', '140200', '矿　区');
INSERT INTO `fcm_areas` VALUES ('140211', '140200', '南郊区');
INSERT INTO `fcm_areas` VALUES ('140212', '140200', '新荣区');
INSERT INTO `fcm_areas` VALUES ('140221', '140200', '阳高县');
INSERT INTO `fcm_areas` VALUES ('140222', '140200', '天镇县');
INSERT INTO `fcm_areas` VALUES ('140223', '140200', '广灵县');
INSERT INTO `fcm_areas` VALUES ('140224', '140200', '灵丘县');
INSERT INTO `fcm_areas` VALUES ('140225', '140200', '浑源县');
INSERT INTO `fcm_areas` VALUES ('140226', '140200', '左云县');
INSERT INTO `fcm_areas` VALUES ('140227', '140200', '大同县');
INSERT INTO `fcm_areas` VALUES ('140301', '140300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140302', '140300', '城　区');
INSERT INTO `fcm_areas` VALUES ('140303', '140300', '矿　区');
INSERT INTO `fcm_areas` VALUES ('140311', '140300', '郊　区');
INSERT INTO `fcm_areas` VALUES ('140321', '140300', '平定县');
INSERT INTO `fcm_areas` VALUES ('140322', '140300', '盂　县');
INSERT INTO `fcm_areas` VALUES ('140401', '140400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140402', '140400', '城　区');
INSERT INTO `fcm_areas` VALUES ('140411', '140400', '郊　区');
INSERT INTO `fcm_areas` VALUES ('140421', '140400', '长治县');
INSERT INTO `fcm_areas` VALUES ('140423', '140400', '襄垣县');
INSERT INTO `fcm_areas` VALUES ('140424', '140400', '屯留县');
INSERT INTO `fcm_areas` VALUES ('140425', '140400', '平顺县');
INSERT INTO `fcm_areas` VALUES ('140426', '140400', '黎城县');
INSERT INTO `fcm_areas` VALUES ('140427', '140400', '壶关县');
INSERT INTO `fcm_areas` VALUES ('140428', '140400', '长子县');
INSERT INTO `fcm_areas` VALUES ('140429', '140400', '武乡县');
INSERT INTO `fcm_areas` VALUES ('140430', '140400', '沁　县');
INSERT INTO `fcm_areas` VALUES ('140431', '140400', '沁源县');
INSERT INTO `fcm_areas` VALUES ('140481', '140400', '潞城市');
INSERT INTO `fcm_areas` VALUES ('140501', '140500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140502', '140500', '城　区');
INSERT INTO `fcm_areas` VALUES ('140521', '140500', '沁水县');
INSERT INTO `fcm_areas` VALUES ('140522', '140500', '阳城县');
INSERT INTO `fcm_areas` VALUES ('140524', '140500', '陵川县');
INSERT INTO `fcm_areas` VALUES ('140525', '140500', '泽州县');
INSERT INTO `fcm_areas` VALUES ('140581', '140500', '高平市');
INSERT INTO `fcm_areas` VALUES ('140601', '140600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140602', '140600', '朔城区');
INSERT INTO `fcm_areas` VALUES ('140603', '140600', '平鲁区');
INSERT INTO `fcm_areas` VALUES ('140621', '140600', '山阴县');
INSERT INTO `fcm_areas` VALUES ('140622', '140600', '应　县');
INSERT INTO `fcm_areas` VALUES ('140623', '140600', '右玉县');
INSERT INTO `fcm_areas` VALUES ('140624', '140600', '怀仁县');
INSERT INTO `fcm_areas` VALUES ('140701', '140700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140702', '140700', '榆次区');
INSERT INTO `fcm_areas` VALUES ('140721', '140700', '榆社县');
INSERT INTO `fcm_areas` VALUES ('140722', '140700', '左权县');
INSERT INTO `fcm_areas` VALUES ('140723', '140700', '和顺县');
INSERT INTO `fcm_areas` VALUES ('140724', '140700', '昔阳县');
INSERT INTO `fcm_areas` VALUES ('140725', '140700', '寿阳县');
INSERT INTO `fcm_areas` VALUES ('140726', '140700', '太谷县');
INSERT INTO `fcm_areas` VALUES ('140727', '140700', '祁　县');
INSERT INTO `fcm_areas` VALUES ('140728', '140700', '平遥县');
INSERT INTO `fcm_areas` VALUES ('140729', '140700', '灵石县');
INSERT INTO `fcm_areas` VALUES ('140781', '140700', '介休市');
INSERT INTO `fcm_areas` VALUES ('140801', '140800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140802', '140800', '盐湖区');
INSERT INTO `fcm_areas` VALUES ('140821', '140800', '临猗县');
INSERT INTO `fcm_areas` VALUES ('140822', '140800', '万荣县');
INSERT INTO `fcm_areas` VALUES ('140823', '140800', '闻喜县');
INSERT INTO `fcm_areas` VALUES ('140824', '140800', '稷山县');
INSERT INTO `fcm_areas` VALUES ('140825', '140800', '新绛县');
INSERT INTO `fcm_areas` VALUES ('140826', '140800', '绛　县');
INSERT INTO `fcm_areas` VALUES ('140827', '140800', '垣曲县');
INSERT INTO `fcm_areas` VALUES ('140828', '140800', '夏　县');
INSERT INTO `fcm_areas` VALUES ('140829', '140800', '平陆县');
INSERT INTO `fcm_areas` VALUES ('140830', '140800', '芮城县');
INSERT INTO `fcm_areas` VALUES ('140881', '140800', '永济市');
INSERT INTO `fcm_areas` VALUES ('140882', '140800', '河津市');
INSERT INTO `fcm_areas` VALUES ('140901', '140900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('140902', '140900', '忻府区');
INSERT INTO `fcm_areas` VALUES ('140921', '140900', '定襄县');
INSERT INTO `fcm_areas` VALUES ('140922', '140900', '五台县');
INSERT INTO `fcm_areas` VALUES ('140923', '140900', '代　县');
INSERT INTO `fcm_areas` VALUES ('140924', '140900', '繁峙县');
INSERT INTO `fcm_areas` VALUES ('140925', '140900', '宁武县');
INSERT INTO `fcm_areas` VALUES ('140926', '140900', '静乐县');
INSERT INTO `fcm_areas` VALUES ('140927', '140900', '神池县');
INSERT INTO `fcm_areas` VALUES ('140928', '140900', '五寨县');
INSERT INTO `fcm_areas` VALUES ('140929', '140900', '岢岚县');
INSERT INTO `fcm_areas` VALUES ('140930', '140900', '河曲县');
INSERT INTO `fcm_areas` VALUES ('140931', '140900', '保德县');
INSERT INTO `fcm_areas` VALUES ('140932', '140900', '偏关县');
INSERT INTO `fcm_areas` VALUES ('140981', '140900', '原平市');
INSERT INTO `fcm_areas` VALUES ('141001', '141000', '市辖区');
INSERT INTO `fcm_areas` VALUES ('141002', '141000', '尧都区');
INSERT INTO `fcm_areas` VALUES ('141021', '141000', '曲沃县');
INSERT INTO `fcm_areas` VALUES ('141022', '141000', '翼城县');
INSERT INTO `fcm_areas` VALUES ('141023', '141000', '襄汾县');
INSERT INTO `fcm_areas` VALUES ('141024', '141000', '洪洞县');
INSERT INTO `fcm_areas` VALUES ('141025', '141000', '古　县');
INSERT INTO `fcm_areas` VALUES ('141026', '141000', '安泽县');
INSERT INTO `fcm_areas` VALUES ('141027', '141000', '浮山县');
INSERT INTO `fcm_areas` VALUES ('141028', '141000', '吉　县');
INSERT INTO `fcm_areas` VALUES ('141029', '141000', '乡宁县');
INSERT INTO `fcm_areas` VALUES ('141030', '141000', '大宁县');
INSERT INTO `fcm_areas` VALUES ('141031', '141000', '隰　县');
INSERT INTO `fcm_areas` VALUES ('141032', '141000', '永和县');
INSERT INTO `fcm_areas` VALUES ('141033', '141000', '蒲　县');
INSERT INTO `fcm_areas` VALUES ('141034', '141000', '汾西县');
INSERT INTO `fcm_areas` VALUES ('141081', '141000', '侯马市');
INSERT INTO `fcm_areas` VALUES ('141082', '141000', '霍州市');
INSERT INTO `fcm_areas` VALUES ('141101', '141100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('141102', '141100', '离石区');
INSERT INTO `fcm_areas` VALUES ('141121', '141100', '文水县');
INSERT INTO `fcm_areas` VALUES ('141122', '141100', '交城县');
INSERT INTO `fcm_areas` VALUES ('141123', '141100', '兴　县');
INSERT INTO `fcm_areas` VALUES ('141124', '141100', '临　县');
INSERT INTO `fcm_areas` VALUES ('141125', '141100', '柳林县');
INSERT INTO `fcm_areas` VALUES ('141126', '141100', '石楼县');
INSERT INTO `fcm_areas` VALUES ('141127', '141100', '岚　县');
INSERT INTO `fcm_areas` VALUES ('141128', '141100', '方山县');
INSERT INTO `fcm_areas` VALUES ('141129', '141100', '中阳县');
INSERT INTO `fcm_areas` VALUES ('141130', '141100', '交口县');
INSERT INTO `fcm_areas` VALUES ('141181', '141100', '孝义市');
INSERT INTO `fcm_areas` VALUES ('141182', '141100', '汾阳市');
INSERT INTO `fcm_areas` VALUES ('150101', '150100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150102', '150100', '新城区');
INSERT INTO `fcm_areas` VALUES ('150103', '150100', '回民区');
INSERT INTO `fcm_areas` VALUES ('150104', '150100', '玉泉区');
INSERT INTO `fcm_areas` VALUES ('150105', '150100', '赛罕区');
INSERT INTO `fcm_areas` VALUES ('150121', '150100', '土默特左旗');
INSERT INTO `fcm_areas` VALUES ('150122', '150100', '托克托县');
INSERT INTO `fcm_areas` VALUES ('150123', '150100', '和林格尔县');
INSERT INTO `fcm_areas` VALUES ('150124', '150100', '清水河县');
INSERT INTO `fcm_areas` VALUES ('150125', '150100', '武川县');
INSERT INTO `fcm_areas` VALUES ('150201', '150200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150202', '150200', '东河区');
INSERT INTO `fcm_areas` VALUES ('150203', '150200', '昆都仑区');
INSERT INTO `fcm_areas` VALUES ('150204', '150200', '青山区');
INSERT INTO `fcm_areas` VALUES ('150205', '150200', '石拐区');
INSERT INTO `fcm_areas` VALUES ('150206', '150200', '白云矿区');
INSERT INTO `fcm_areas` VALUES ('150207', '150200', '九原区');
INSERT INTO `fcm_areas` VALUES ('150221', '150200', '土默特右旗');
INSERT INTO `fcm_areas` VALUES ('150222', '150200', '固阳县');
INSERT INTO `fcm_areas` VALUES ('150223', '150200', '达尔罕茂明安联合旗');
INSERT INTO `fcm_areas` VALUES ('150301', '150300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150302', '150300', '海勃湾区');
INSERT INTO `fcm_areas` VALUES ('150303', '150300', '海南区');
INSERT INTO `fcm_areas` VALUES ('150304', '150300', '乌达区');
INSERT INTO `fcm_areas` VALUES ('150401', '150400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150402', '150400', '红山区');
INSERT INTO `fcm_areas` VALUES ('150403', '150400', '元宝山区');
INSERT INTO `fcm_areas` VALUES ('150404', '150400', '松山区');
INSERT INTO `fcm_areas` VALUES ('150421', '150400', '阿鲁科尔沁旗');
INSERT INTO `fcm_areas` VALUES ('150422', '150400', '巴林左旗');
INSERT INTO `fcm_areas` VALUES ('150423', '150400', '巴林右旗');
INSERT INTO `fcm_areas` VALUES ('150424', '150400', '林西县');
INSERT INTO `fcm_areas` VALUES ('150425', '150400', '克什克腾旗');
INSERT INTO `fcm_areas` VALUES ('150426', '150400', '翁牛特旗');
INSERT INTO `fcm_areas` VALUES ('150428', '150400', '喀喇沁旗');
INSERT INTO `fcm_areas` VALUES ('150429', '150400', '宁城县');
INSERT INTO `fcm_areas` VALUES ('150430', '150400', '敖汉旗');
INSERT INTO `fcm_areas` VALUES ('150501', '150500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150502', '150500', '科尔沁区');
INSERT INTO `fcm_areas` VALUES ('150521', '150500', '科尔沁左翼中旗');
INSERT INTO `fcm_areas` VALUES ('150522', '150500', '科尔沁左翼后旗');
INSERT INTO `fcm_areas` VALUES ('150523', '150500', '开鲁县');
INSERT INTO `fcm_areas` VALUES ('150524', '150500', '库伦旗');
INSERT INTO `fcm_areas` VALUES ('150525', '150500', '奈曼旗');
INSERT INTO `fcm_areas` VALUES ('150526', '150500', '扎鲁特旗');
INSERT INTO `fcm_areas` VALUES ('150581', '150500', '霍林郭勒市');
INSERT INTO `fcm_areas` VALUES ('150602', '150600', '东胜区');
INSERT INTO `fcm_areas` VALUES ('150621', '150600', '达拉特旗');
INSERT INTO `fcm_areas` VALUES ('150622', '150600', '准格尔旗');
INSERT INTO `fcm_areas` VALUES ('150623', '150600', '鄂托克前旗');
INSERT INTO `fcm_areas` VALUES ('150624', '150600', '鄂托克旗');
INSERT INTO `fcm_areas` VALUES ('150625', '150600', '杭锦旗');
INSERT INTO `fcm_areas` VALUES ('150626', '150600', '乌审旗');
INSERT INTO `fcm_areas` VALUES ('150627', '150600', '伊金霍洛旗');
INSERT INTO `fcm_areas` VALUES ('150701', '150700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150702', '150700', '海拉尔区');
INSERT INTO `fcm_areas` VALUES ('150721', '150700', '阿荣旗');
INSERT INTO `fcm_areas` VALUES ('150722', '150700', '莫力达瓦达斡尔族自治旗');
INSERT INTO `fcm_areas` VALUES ('150723', '150700', '鄂伦春自治旗');
INSERT INTO `fcm_areas` VALUES ('150724', '150700', '鄂温克族自治旗');
INSERT INTO `fcm_areas` VALUES ('150725', '150700', '陈巴尔虎旗');
INSERT INTO `fcm_areas` VALUES ('150726', '150700', '新巴尔虎左旗');
INSERT INTO `fcm_areas` VALUES ('150727', '150700', '新巴尔虎右旗');
INSERT INTO `fcm_areas` VALUES ('150781', '150700', '满洲里市');
INSERT INTO `fcm_areas` VALUES ('150782', '150700', '牙克石市');
INSERT INTO `fcm_areas` VALUES ('150783', '150700', '扎兰屯市');
INSERT INTO `fcm_areas` VALUES ('150784', '150700', '额尔古纳市');
INSERT INTO `fcm_areas` VALUES ('150785', '150700', '根河市');
INSERT INTO `fcm_areas` VALUES ('150801', '150800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150802', '150800', '临河区');
INSERT INTO `fcm_areas` VALUES ('150821', '150800', '五原县');
INSERT INTO `fcm_areas` VALUES ('150822', '150800', '磴口县');
INSERT INTO `fcm_areas` VALUES ('150823', '150800', '乌拉特前旗');
INSERT INTO `fcm_areas` VALUES ('150824', '150800', '乌拉特中旗');
INSERT INTO `fcm_areas` VALUES ('150825', '150800', '乌拉特后旗');
INSERT INTO `fcm_areas` VALUES ('150826', '150800', '杭锦后旗');
INSERT INTO `fcm_areas` VALUES ('150901', '150900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('150902', '150900', '集宁区');
INSERT INTO `fcm_areas` VALUES ('150921', '150900', '卓资县');
INSERT INTO `fcm_areas` VALUES ('150922', '150900', '化德县');
INSERT INTO `fcm_areas` VALUES ('150923', '150900', '商都县');
INSERT INTO `fcm_areas` VALUES ('150924', '150900', '兴和县');
INSERT INTO `fcm_areas` VALUES ('150925', '150900', '凉城县');
INSERT INTO `fcm_areas` VALUES ('150926', '150900', '察哈尔右翼前旗');
INSERT INTO `fcm_areas` VALUES ('150927', '150900', '察哈尔右翼中旗');
INSERT INTO `fcm_areas` VALUES ('150928', '150900', '察哈尔右翼后旗');
INSERT INTO `fcm_areas` VALUES ('150929', '150900', '四子王旗');
INSERT INTO `fcm_areas` VALUES ('150981', '150900', '丰镇市');
INSERT INTO `fcm_areas` VALUES ('152201', '152200', '乌兰浩特市');
INSERT INTO `fcm_areas` VALUES ('152202', '152200', '阿尔山市');
INSERT INTO `fcm_areas` VALUES ('152221', '152200', '科尔沁右翼前旗');
INSERT INTO `fcm_areas` VALUES ('152222', '152200', '科尔沁右翼中旗');
INSERT INTO `fcm_areas` VALUES ('152223', '152200', '扎赉特旗');
INSERT INTO `fcm_areas` VALUES ('152224', '152200', '突泉县');
INSERT INTO `fcm_areas` VALUES ('152501', '152500', '二连浩特市');
INSERT INTO `fcm_areas` VALUES ('152502', '152500', '锡林浩特市');
INSERT INTO `fcm_areas` VALUES ('152522', '152500', '阿巴嘎旗');
INSERT INTO `fcm_areas` VALUES ('152523', '152500', '苏尼特左旗');
INSERT INTO `fcm_areas` VALUES ('152524', '152500', '苏尼特右旗');
INSERT INTO `fcm_areas` VALUES ('152525', '152500', '东乌珠穆沁旗');
INSERT INTO `fcm_areas` VALUES ('152526', '152500', '西乌珠穆沁旗');
INSERT INTO `fcm_areas` VALUES ('152527', '152500', '太仆寺旗');
INSERT INTO `fcm_areas` VALUES ('152528', '152500', '镶黄旗');
INSERT INTO `fcm_areas` VALUES ('152529', '152500', '正镶白旗');
INSERT INTO `fcm_areas` VALUES ('152530', '152500', '正蓝旗');
INSERT INTO `fcm_areas` VALUES ('152531', '152500', '多伦县');
INSERT INTO `fcm_areas` VALUES ('152921', '152900', '阿拉善左旗');
INSERT INTO `fcm_areas` VALUES ('152922', '152900', '阿拉善右旗');
INSERT INTO `fcm_areas` VALUES ('152923', '152900', '额济纳旗');
INSERT INTO `fcm_areas` VALUES ('210101', '210100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210102', '210100', '和平区');
INSERT INTO `fcm_areas` VALUES ('210103', '210100', '沈河区');
INSERT INTO `fcm_areas` VALUES ('210104', '210100', '大东区');
INSERT INTO `fcm_areas` VALUES ('210105', '210100', '皇姑区');
INSERT INTO `fcm_areas` VALUES ('210106', '210100', '铁西区');
INSERT INTO `fcm_areas` VALUES ('210111', '210100', '苏家屯区');
INSERT INTO `fcm_areas` VALUES ('210112', '210100', '东陵区');
INSERT INTO `fcm_areas` VALUES ('210113', '210100', '新城子区');
INSERT INTO `fcm_areas` VALUES ('210114', '210100', '于洪区');
INSERT INTO `fcm_areas` VALUES ('210122', '210100', '辽中县');
INSERT INTO `fcm_areas` VALUES ('210123', '210100', '康平县');
INSERT INTO `fcm_areas` VALUES ('210124', '210100', '法库县');
INSERT INTO `fcm_areas` VALUES ('210181', '210100', '新民市');
INSERT INTO `fcm_areas` VALUES ('210201', '210200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210202', '210200', '中山区');
INSERT INTO `fcm_areas` VALUES ('210203', '210200', '西岗区');
INSERT INTO `fcm_areas` VALUES ('210204', '210200', '沙河口区');
INSERT INTO `fcm_areas` VALUES ('210211', '210200', '甘井子区');
INSERT INTO `fcm_areas` VALUES ('210212', '210200', '旅顺口区');
INSERT INTO `fcm_areas` VALUES ('210213', '210200', '金州区');
INSERT INTO `fcm_areas` VALUES ('210224', '210200', '长海县');
INSERT INTO `fcm_areas` VALUES ('210281', '210200', '瓦房店市');
INSERT INTO `fcm_areas` VALUES ('210282', '210200', '普兰店市');
INSERT INTO `fcm_areas` VALUES ('210283', '210200', '庄河市');
INSERT INTO `fcm_areas` VALUES ('210301', '210300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210302', '210300', '铁东区');
INSERT INTO `fcm_areas` VALUES ('210303', '210300', '铁西区');
INSERT INTO `fcm_areas` VALUES ('210304', '210300', '立山区');
INSERT INTO `fcm_areas` VALUES ('210311', '210300', '千山区');
INSERT INTO `fcm_areas` VALUES ('210321', '210300', '台安县');
INSERT INTO `fcm_areas` VALUES ('210323', '210300', '岫岩满族自治县');
INSERT INTO `fcm_areas` VALUES ('210381', '210300', '海城市');
INSERT INTO `fcm_areas` VALUES ('210401', '210400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210402', '210400', '新抚区');
INSERT INTO `fcm_areas` VALUES ('210403', '210400', '东洲区');
INSERT INTO `fcm_areas` VALUES ('210404', '210400', '望花区');
INSERT INTO `fcm_areas` VALUES ('210411', '210400', '顺城区');
INSERT INTO `fcm_areas` VALUES ('210421', '210400', '抚顺县');
INSERT INTO `fcm_areas` VALUES ('210422', '210400', '新宾满族自治县');
INSERT INTO `fcm_areas` VALUES ('210423', '210400', '清原满族自治县');
INSERT INTO `fcm_areas` VALUES ('210501', '210500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210502', '210500', '平山区');
INSERT INTO `fcm_areas` VALUES ('210503', '210500', '溪湖区');
INSERT INTO `fcm_areas` VALUES ('210504', '210500', '明山区');
INSERT INTO `fcm_areas` VALUES ('210505', '210500', '南芬区');
INSERT INTO `fcm_areas` VALUES ('210521', '210500', '本溪满族自治县');
INSERT INTO `fcm_areas` VALUES ('210522', '210500', '桓仁满族自治县');
INSERT INTO `fcm_areas` VALUES ('210601', '210600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210602', '210600', '元宝区');
INSERT INTO `fcm_areas` VALUES ('210603', '210600', '振兴区');
INSERT INTO `fcm_areas` VALUES ('210604', '210600', '振安区');
INSERT INTO `fcm_areas` VALUES ('210624', '210600', '宽甸满族自治县');
INSERT INTO `fcm_areas` VALUES ('210681', '210600', '东港市');
INSERT INTO `fcm_areas` VALUES ('210682', '210600', '凤城市');
INSERT INTO `fcm_areas` VALUES ('210701', '210700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210702', '210700', '古塔区');
INSERT INTO `fcm_areas` VALUES ('210703', '210700', '凌河区');
INSERT INTO `fcm_areas` VALUES ('210711', '210700', '太和区');
INSERT INTO `fcm_areas` VALUES ('210726', '210700', '黑山县');
INSERT INTO `fcm_areas` VALUES ('210727', '210700', '义　县');
INSERT INTO `fcm_areas` VALUES ('210781', '210700', '凌海市');
INSERT INTO `fcm_areas` VALUES ('210782', '210700', '北宁市');
INSERT INTO `fcm_areas` VALUES ('210801', '210800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210802', '210800', '站前区');
INSERT INTO `fcm_areas` VALUES ('210803', '210800', '西市区');
INSERT INTO `fcm_areas` VALUES ('210804', '210800', '鲅鱼圈区');
INSERT INTO `fcm_areas` VALUES ('210811', '210800', '老边区');
INSERT INTO `fcm_areas` VALUES ('210881', '210800', '盖州市');
INSERT INTO `fcm_areas` VALUES ('210882', '210800', '大石桥市');
INSERT INTO `fcm_areas` VALUES ('210901', '210900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('210902', '210900', '海州区');
INSERT INTO `fcm_areas` VALUES ('210903', '210900', '新邱区');
INSERT INTO `fcm_areas` VALUES ('210904', '210900', '太平区');
INSERT INTO `fcm_areas` VALUES ('210905', '210900', '清河门区');
INSERT INTO `fcm_areas` VALUES ('210911', '210900', '细河区');
INSERT INTO `fcm_areas` VALUES ('210921', '210900', '阜新蒙古族自治县');
INSERT INTO `fcm_areas` VALUES ('210922', '210900', '彰武县');
INSERT INTO `fcm_areas` VALUES ('211001', '211000', '市辖区');
INSERT INTO `fcm_areas` VALUES ('211002', '211000', '白塔区');
INSERT INTO `fcm_areas` VALUES ('211003', '211000', '文圣区');
INSERT INTO `fcm_areas` VALUES ('211004', '211000', '宏伟区');
INSERT INTO `fcm_areas` VALUES ('211005', '211000', '弓长岭区');
INSERT INTO `fcm_areas` VALUES ('211011', '211000', '太子河区');
INSERT INTO `fcm_areas` VALUES ('211021', '211000', '辽阳县');
INSERT INTO `fcm_areas` VALUES ('211081', '211000', '灯塔市');
INSERT INTO `fcm_areas` VALUES ('211101', '211100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('211102', '211100', '双台子区');
INSERT INTO `fcm_areas` VALUES ('211103', '211100', '兴隆台区');
INSERT INTO `fcm_areas` VALUES ('211121', '211100', '大洼县');
INSERT INTO `fcm_areas` VALUES ('211122', '211100', '盘山县');
INSERT INTO `fcm_areas` VALUES ('211201', '211200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('211202', '211200', '银州区');
INSERT INTO `fcm_areas` VALUES ('211204', '211200', '清河区');
INSERT INTO `fcm_areas` VALUES ('211221', '211200', '铁岭县');
INSERT INTO `fcm_areas` VALUES ('211223', '211200', '西丰县');
INSERT INTO `fcm_areas` VALUES ('211224', '211200', '昌图县');
INSERT INTO `fcm_areas` VALUES ('211281', '211200', '调兵山市');
INSERT INTO `fcm_areas` VALUES ('211282', '211200', '开原市');
INSERT INTO `fcm_areas` VALUES ('211301', '211300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('211302', '211300', '双塔区');
INSERT INTO `fcm_areas` VALUES ('211303', '211300', '龙城区');
INSERT INTO `fcm_areas` VALUES ('211321', '211300', '朝阳县');
INSERT INTO `fcm_areas` VALUES ('211322', '211300', '建平县');
INSERT INTO `fcm_areas` VALUES ('211324', '211300', '喀喇沁左翼蒙古族自治县');
INSERT INTO `fcm_areas` VALUES ('211381', '211300', '北票市');
INSERT INTO `fcm_areas` VALUES ('211382', '211300', '凌源市');
INSERT INTO `fcm_areas` VALUES ('211401', '211400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('211402', '211400', '连山区');
INSERT INTO `fcm_areas` VALUES ('211403', '211400', '龙港区');
INSERT INTO `fcm_areas` VALUES ('211404', '211400', '南票区');
INSERT INTO `fcm_areas` VALUES ('211421', '211400', '绥中县');
INSERT INTO `fcm_areas` VALUES ('211422', '211400', '建昌县');
INSERT INTO `fcm_areas` VALUES ('211481', '211400', '兴城市');
INSERT INTO `fcm_areas` VALUES ('220101', '220100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220102', '220100', '南关区');
INSERT INTO `fcm_areas` VALUES ('220103', '220100', '宽城区');
INSERT INTO `fcm_areas` VALUES ('220104', '220100', '朝阳区');
INSERT INTO `fcm_areas` VALUES ('220105', '220100', '二道区');
INSERT INTO `fcm_areas` VALUES ('220106', '220100', '绿园区');
INSERT INTO `fcm_areas` VALUES ('220112', '220100', '双阳区');
INSERT INTO `fcm_areas` VALUES ('220122', '220100', '农安县');
INSERT INTO `fcm_areas` VALUES ('220181', '220100', '九台市');
INSERT INTO `fcm_areas` VALUES ('220182', '220100', '榆树市');
INSERT INTO `fcm_areas` VALUES ('220183', '220100', '德惠市');
INSERT INTO `fcm_areas` VALUES ('220201', '220200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220202', '220200', '昌邑区');
INSERT INTO `fcm_areas` VALUES ('220203', '220200', '龙潭区');
INSERT INTO `fcm_areas` VALUES ('220204', '220200', '船营区');
INSERT INTO `fcm_areas` VALUES ('220211', '220200', '丰满区');
INSERT INTO `fcm_areas` VALUES ('220221', '220200', '永吉县');
INSERT INTO `fcm_areas` VALUES ('220281', '220200', '蛟河市');
INSERT INTO `fcm_areas` VALUES ('220282', '220200', '桦甸市');
INSERT INTO `fcm_areas` VALUES ('220283', '220200', '舒兰市');
INSERT INTO `fcm_areas` VALUES ('220284', '220200', '磐石市');
INSERT INTO `fcm_areas` VALUES ('220301', '220300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220302', '220300', '铁西区');
INSERT INTO `fcm_areas` VALUES ('220303', '220300', '铁东区');
INSERT INTO `fcm_areas` VALUES ('220322', '220300', '梨树县');
INSERT INTO `fcm_areas` VALUES ('220323', '220300', '伊通满族自治县');
INSERT INTO `fcm_areas` VALUES ('220381', '220300', '公主岭市');
INSERT INTO `fcm_areas` VALUES ('220382', '220300', '双辽市');
INSERT INTO `fcm_areas` VALUES ('220401', '220400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220402', '220400', '龙山区');
INSERT INTO `fcm_areas` VALUES ('220403', '220400', '西安区');
INSERT INTO `fcm_areas` VALUES ('220421', '220400', '东丰县');
INSERT INTO `fcm_areas` VALUES ('220422', '220400', '东辽县');
INSERT INTO `fcm_areas` VALUES ('220501', '220500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220502', '220500', '东昌区');
INSERT INTO `fcm_areas` VALUES ('220503', '220500', '二道江区');
INSERT INTO `fcm_areas` VALUES ('220521', '220500', '通化县');
INSERT INTO `fcm_areas` VALUES ('220523', '220500', '辉南县');
INSERT INTO `fcm_areas` VALUES ('220524', '220500', '柳河县');
INSERT INTO `fcm_areas` VALUES ('220581', '220500', '梅河口市');
INSERT INTO `fcm_areas` VALUES ('220582', '220500', '集安市');
INSERT INTO `fcm_areas` VALUES ('220601', '220600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220602', '220600', '八道江区');
INSERT INTO `fcm_areas` VALUES ('220621', '220600', '抚松县');
INSERT INTO `fcm_areas` VALUES ('220622', '220600', '靖宇县');
INSERT INTO `fcm_areas` VALUES ('220623', '220600', '长白朝鲜族自治县');
INSERT INTO `fcm_areas` VALUES ('220625', '220600', '江源县');
INSERT INTO `fcm_areas` VALUES ('220681', '220600', '临江市');
INSERT INTO `fcm_areas` VALUES ('220701', '220700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220702', '220700', '宁江区');
INSERT INTO `fcm_areas` VALUES ('220721', '220700', '前郭尔罗斯蒙古族自治县');
INSERT INTO `fcm_areas` VALUES ('220722', '220700', '长岭县');
INSERT INTO `fcm_areas` VALUES ('220723', '220700', '乾安县');
INSERT INTO `fcm_areas` VALUES ('220724', '220700', '扶余县');
INSERT INTO `fcm_areas` VALUES ('220801', '220800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('220802', '220800', '洮北区');
INSERT INTO `fcm_areas` VALUES ('220821', '220800', '镇赉县');
INSERT INTO `fcm_areas` VALUES ('220822', '220800', '通榆县');
INSERT INTO `fcm_areas` VALUES ('220881', '220800', '洮南市');
INSERT INTO `fcm_areas` VALUES ('220882', '220800', '大安市');
INSERT INTO `fcm_areas` VALUES ('222401', '222400', '延吉市');
INSERT INTO `fcm_areas` VALUES ('222402', '222400', '图们市');
INSERT INTO `fcm_areas` VALUES ('222403', '222400', '敦化市');
INSERT INTO `fcm_areas` VALUES ('222404', '222400', '珲春市');
INSERT INTO `fcm_areas` VALUES ('222405', '222400', '龙井市');
INSERT INTO `fcm_areas` VALUES ('222406', '222400', '和龙市');
INSERT INTO `fcm_areas` VALUES ('222424', '222400', '汪清县');
INSERT INTO `fcm_areas` VALUES ('222426', '222400', '安图县');
INSERT INTO `fcm_areas` VALUES ('230101', '230100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230102', '230100', '道里区');
INSERT INTO `fcm_areas` VALUES ('230103', '230100', '南岗区');
INSERT INTO `fcm_areas` VALUES ('230104', '230100', '道外区');
INSERT INTO `fcm_areas` VALUES ('230106', '230100', '香坊区');
INSERT INTO `fcm_areas` VALUES ('230107', '230100', '动力区');
INSERT INTO `fcm_areas` VALUES ('230108', '230100', '平房区');
INSERT INTO `fcm_areas` VALUES ('230109', '230100', '松北区');
INSERT INTO `fcm_areas` VALUES ('230111', '230100', '呼兰区');
INSERT INTO `fcm_areas` VALUES ('230123', '230100', '依兰县');
INSERT INTO `fcm_areas` VALUES ('230124', '230100', '方正县');
INSERT INTO `fcm_areas` VALUES ('230125', '230100', '宾　县');
INSERT INTO `fcm_areas` VALUES ('230126', '230100', '巴彦县');
INSERT INTO `fcm_areas` VALUES ('230127', '230100', '木兰县');
INSERT INTO `fcm_areas` VALUES ('230128', '230100', '通河县');
INSERT INTO `fcm_areas` VALUES ('230129', '230100', '延寿县');
INSERT INTO `fcm_areas` VALUES ('230181', '230100', '阿城市');
INSERT INTO `fcm_areas` VALUES ('230182', '230100', '双城市');
INSERT INTO `fcm_areas` VALUES ('230183', '230100', '尚志市');
INSERT INTO `fcm_areas` VALUES ('230184', '230100', '五常市');
INSERT INTO `fcm_areas` VALUES ('230201', '230200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230202', '230200', '龙沙区');
INSERT INTO `fcm_areas` VALUES ('230203', '230200', '建华区');
INSERT INTO `fcm_areas` VALUES ('230204', '230200', '铁锋区');
INSERT INTO `fcm_areas` VALUES ('230205', '230200', '昂昂溪区');
INSERT INTO `fcm_areas` VALUES ('230206', '230200', '富拉尔基区');
INSERT INTO `fcm_areas` VALUES ('230207', '230200', '碾子山区');
INSERT INTO `fcm_areas` VALUES ('230208', '230200', '梅里斯达斡尔族区');
INSERT INTO `fcm_areas` VALUES ('230221', '230200', '龙江县');
INSERT INTO `fcm_areas` VALUES ('230223', '230200', '依安县');
INSERT INTO `fcm_areas` VALUES ('230224', '230200', '泰来县');
INSERT INTO `fcm_areas` VALUES ('230225', '230200', '甘南县');
INSERT INTO `fcm_areas` VALUES ('230227', '230200', '富裕县');
INSERT INTO `fcm_areas` VALUES ('230229', '230200', '克山县');
INSERT INTO `fcm_areas` VALUES ('230230', '230200', '克东县');
INSERT INTO `fcm_areas` VALUES ('230231', '230200', '拜泉县');
INSERT INTO `fcm_areas` VALUES ('230281', '230200', '讷河市');
INSERT INTO `fcm_areas` VALUES ('230301', '230300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230302', '230300', '鸡冠区');
INSERT INTO `fcm_areas` VALUES ('230303', '230300', '恒山区');
INSERT INTO `fcm_areas` VALUES ('230304', '230300', '滴道区');
INSERT INTO `fcm_areas` VALUES ('230305', '230300', '梨树区');
INSERT INTO `fcm_areas` VALUES ('230306', '230300', '城子河区');
INSERT INTO `fcm_areas` VALUES ('230307', '230300', '麻山区');
INSERT INTO `fcm_areas` VALUES ('230321', '230300', '鸡东县');
INSERT INTO `fcm_areas` VALUES ('230381', '230300', '虎林市');
INSERT INTO `fcm_areas` VALUES ('230382', '230300', '密山市');
INSERT INTO `fcm_areas` VALUES ('230401', '230400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230402', '230400', '向阳区');
INSERT INTO `fcm_areas` VALUES ('230403', '230400', '工农区');
INSERT INTO `fcm_areas` VALUES ('230404', '230400', '南山区');
INSERT INTO `fcm_areas` VALUES ('230405', '230400', '兴安区');
INSERT INTO `fcm_areas` VALUES ('230406', '230400', '东山区');
INSERT INTO `fcm_areas` VALUES ('230407', '230400', '兴山区');
INSERT INTO `fcm_areas` VALUES ('230421', '230400', '萝北县');
INSERT INTO `fcm_areas` VALUES ('230422', '230400', '绥滨县');
INSERT INTO `fcm_areas` VALUES ('230501', '230500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230502', '230500', '尖山区');
INSERT INTO `fcm_areas` VALUES ('230503', '230500', '岭东区');
INSERT INTO `fcm_areas` VALUES ('230505', '230500', '四方台区');
INSERT INTO `fcm_areas` VALUES ('230506', '230500', '宝山区');
INSERT INTO `fcm_areas` VALUES ('230521', '230500', '集贤县');
INSERT INTO `fcm_areas` VALUES ('230522', '230500', '友谊县');
INSERT INTO `fcm_areas` VALUES ('230523', '230500', '宝清县');
INSERT INTO `fcm_areas` VALUES ('230524', '230500', '饶河县');
INSERT INTO `fcm_areas` VALUES ('230601', '230600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230602', '230600', '萨尔图区');
INSERT INTO `fcm_areas` VALUES ('230603', '230600', '龙凤区');
INSERT INTO `fcm_areas` VALUES ('230604', '230600', '让胡路区');
INSERT INTO `fcm_areas` VALUES ('230605', '230600', '红岗区');
INSERT INTO `fcm_areas` VALUES ('230606', '230600', '大同区');
INSERT INTO `fcm_areas` VALUES ('230621', '230600', '肇州县');
INSERT INTO `fcm_areas` VALUES ('230622', '230600', '肇源县');
INSERT INTO `fcm_areas` VALUES ('230623', '230600', '林甸县');
INSERT INTO `fcm_areas` VALUES ('230624', '230600', '杜尔伯特蒙古族自治县');
INSERT INTO `fcm_areas` VALUES ('230701', '230700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230702', '230700', '伊春区');
INSERT INTO `fcm_areas` VALUES ('230703', '230700', '南岔区');
INSERT INTO `fcm_areas` VALUES ('230704', '230700', '友好区');
INSERT INTO `fcm_areas` VALUES ('230705', '230700', '西林区');
INSERT INTO `fcm_areas` VALUES ('230706', '230700', '翠峦区');
INSERT INTO `fcm_areas` VALUES ('230707', '230700', '新青区');
INSERT INTO `fcm_areas` VALUES ('230708', '230700', '美溪区');
INSERT INTO `fcm_areas` VALUES ('230709', '230700', '金山屯区');
INSERT INTO `fcm_areas` VALUES ('230710', '230700', '五营区');
INSERT INTO `fcm_areas` VALUES ('230711', '230700', '乌马河区');
INSERT INTO `fcm_areas` VALUES ('230712', '230700', '汤旺河区');
INSERT INTO `fcm_areas` VALUES ('230713', '230700', '带岭区');
INSERT INTO `fcm_areas` VALUES ('230714', '230700', '乌伊岭区');
INSERT INTO `fcm_areas` VALUES ('230715', '230700', '红星区');
INSERT INTO `fcm_areas` VALUES ('230716', '230700', '上甘岭区');
INSERT INTO `fcm_areas` VALUES ('230722', '230700', '嘉荫县');
INSERT INTO `fcm_areas` VALUES ('230781', '230700', '铁力市');
INSERT INTO `fcm_areas` VALUES ('230801', '230800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230802', '230800', '永红区');
INSERT INTO `fcm_areas` VALUES ('230803', '230800', '向阳区');
INSERT INTO `fcm_areas` VALUES ('230804', '230800', '前进区');
INSERT INTO `fcm_areas` VALUES ('230805', '230800', '东风区');
INSERT INTO `fcm_areas` VALUES ('230811', '230800', '郊　区');
INSERT INTO `fcm_areas` VALUES ('230822', '230800', '桦南县');
INSERT INTO `fcm_areas` VALUES ('230826', '230800', '桦川县');
INSERT INTO `fcm_areas` VALUES ('230828', '230800', '汤原县');
INSERT INTO `fcm_areas` VALUES ('230833', '230800', '抚远县');
INSERT INTO `fcm_areas` VALUES ('230881', '230800', '同江市');
INSERT INTO `fcm_areas` VALUES ('230882', '230800', '富锦市');
INSERT INTO `fcm_areas` VALUES ('230901', '230900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('230902', '230900', '新兴区');
INSERT INTO `fcm_areas` VALUES ('230903', '230900', '桃山区');
INSERT INTO `fcm_areas` VALUES ('230904', '230900', '茄子河区');
INSERT INTO `fcm_areas` VALUES ('230921', '230900', '勃利县');
INSERT INTO `fcm_areas` VALUES ('231001', '231000', '市辖区');
INSERT INTO `fcm_areas` VALUES ('231002', '231000', '东安区');
INSERT INTO `fcm_areas` VALUES ('231003', '231000', '阳明区');
INSERT INTO `fcm_areas` VALUES ('231004', '231000', '爱民区');
INSERT INTO `fcm_areas` VALUES ('231005', '231000', '西安区');
INSERT INTO `fcm_areas` VALUES ('231024', '231000', '东宁县');
INSERT INTO `fcm_areas` VALUES ('231025', '231000', '林口县');
INSERT INTO `fcm_areas` VALUES ('231081', '231000', '绥芬河市');
INSERT INTO `fcm_areas` VALUES ('231083', '231000', '海林市');
INSERT INTO `fcm_areas` VALUES ('231084', '231000', '宁安市');
INSERT INTO `fcm_areas` VALUES ('231085', '231000', '穆棱市');
INSERT INTO `fcm_areas` VALUES ('231101', '231100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('231102', '231100', '爱辉区');
INSERT INTO `fcm_areas` VALUES ('231121', '231100', '嫩江县');
INSERT INTO `fcm_areas` VALUES ('231123', '231100', '逊克县');
INSERT INTO `fcm_areas` VALUES ('231124', '231100', '孙吴县');
INSERT INTO `fcm_areas` VALUES ('231181', '231100', '北安市');
INSERT INTO `fcm_areas` VALUES ('231182', '231100', '五大连池市');
INSERT INTO `fcm_areas` VALUES ('231201', '231200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('231202', '231200', '北林区');
INSERT INTO `fcm_areas` VALUES ('231221', '231200', '望奎县');
INSERT INTO `fcm_areas` VALUES ('231222', '231200', '兰西县');
INSERT INTO `fcm_areas` VALUES ('231223', '231200', '青冈县');
INSERT INTO `fcm_areas` VALUES ('231224', '231200', '庆安县');
INSERT INTO `fcm_areas` VALUES ('231225', '231200', '明水县');
INSERT INTO `fcm_areas` VALUES ('231226', '231200', '绥棱县');
INSERT INTO `fcm_areas` VALUES ('231281', '231200', '安达市');
INSERT INTO `fcm_areas` VALUES ('231282', '231200', '肇东市');
INSERT INTO `fcm_areas` VALUES ('231283', '231200', '海伦市');
INSERT INTO `fcm_areas` VALUES ('232721', '232700', '呼玛县');
INSERT INTO `fcm_areas` VALUES ('232722', '232700', '塔河县');
INSERT INTO `fcm_areas` VALUES ('232723', '232700', '漠河县');
INSERT INTO `fcm_areas` VALUES ('310101', '310100', '黄浦区');
INSERT INTO `fcm_areas` VALUES ('310103', '310100', '卢湾区');
INSERT INTO `fcm_areas` VALUES ('310104', '310100', '徐汇区');
INSERT INTO `fcm_areas` VALUES ('310105', '310100', '长宁区');
INSERT INTO `fcm_areas` VALUES ('310106', '310100', '静安区');
INSERT INTO `fcm_areas` VALUES ('310107', '310100', '普陀区');
INSERT INTO `fcm_areas` VALUES ('310108', '310100', '闸北区');
INSERT INTO `fcm_areas` VALUES ('310109', '310100', '虹口区');
INSERT INTO `fcm_areas` VALUES ('310110', '310100', '杨浦区');
INSERT INTO `fcm_areas` VALUES ('310112', '310100', '闵行区');
INSERT INTO `fcm_areas` VALUES ('310113', '310100', '宝山区');
INSERT INTO `fcm_areas` VALUES ('310114', '310100', '嘉定区');
INSERT INTO `fcm_areas` VALUES ('310115', '310100', '浦东新区');
INSERT INTO `fcm_areas` VALUES ('310116', '310100', '金山区');
INSERT INTO `fcm_areas` VALUES ('310117', '310100', '松江区');
INSERT INTO `fcm_areas` VALUES ('310118', '310100', '青浦区');
INSERT INTO `fcm_areas` VALUES ('310119', '310100', '南汇区');
INSERT INTO `fcm_areas` VALUES ('310120', '310100', '奉贤区');
INSERT INTO `fcm_areas` VALUES ('310230', '310100', '崇明县');
INSERT INTO `fcm_areas` VALUES ('320101', '320100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320102', '320100', '玄武区');
INSERT INTO `fcm_areas` VALUES ('320103', '320100', '白下区');
INSERT INTO `fcm_areas` VALUES ('320104', '320100', '秦淮区');
INSERT INTO `fcm_areas` VALUES ('320105', '320100', '建邺区');
INSERT INTO `fcm_areas` VALUES ('320106', '320100', '鼓楼区');
INSERT INTO `fcm_areas` VALUES ('320107', '320100', '下关区');
INSERT INTO `fcm_areas` VALUES ('320111', '320100', '浦口区');
INSERT INTO `fcm_areas` VALUES ('320113', '320100', '栖霞区');
INSERT INTO `fcm_areas` VALUES ('320114', '320100', '雨花台区');
INSERT INTO `fcm_areas` VALUES ('320115', '320100', '江宁区');
INSERT INTO `fcm_areas` VALUES ('320116', '320100', '六合区');
INSERT INTO `fcm_areas` VALUES ('320124', '320100', '溧水县');
INSERT INTO `fcm_areas` VALUES ('320125', '320100', '高淳县');
INSERT INTO `fcm_areas` VALUES ('320201', '320200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320202', '320200', '崇安区');
INSERT INTO `fcm_areas` VALUES ('320203', '320200', '南长区');
INSERT INTO `fcm_areas` VALUES ('320204', '320200', '北塘区');
INSERT INTO `fcm_areas` VALUES ('320205', '320200', '锡山区');
INSERT INTO `fcm_areas` VALUES ('320206', '320200', '惠山区');
INSERT INTO `fcm_areas` VALUES ('320211', '320200', '滨湖区');
INSERT INTO `fcm_areas` VALUES ('320281', '320200', '江阴市');
INSERT INTO `fcm_areas` VALUES ('320282', '320200', '宜兴市');
INSERT INTO `fcm_areas` VALUES ('320301', '320300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320302', '320300', '鼓楼区');
INSERT INTO `fcm_areas` VALUES ('320303', '320300', '云龙区');
INSERT INTO `fcm_areas` VALUES ('320304', '320300', '九里区');
INSERT INTO `fcm_areas` VALUES ('320305', '320300', '贾汪区');
INSERT INTO `fcm_areas` VALUES ('320311', '320300', '泉山区');
INSERT INTO `fcm_areas` VALUES ('320321', '320300', '丰　县');
INSERT INTO `fcm_areas` VALUES ('320322', '320300', '沛　县');
INSERT INTO `fcm_areas` VALUES ('320323', '320300', '铜山县');
INSERT INTO `fcm_areas` VALUES ('320324', '320300', '睢宁县');
INSERT INTO `fcm_areas` VALUES ('320381', '320300', '新沂市');
INSERT INTO `fcm_areas` VALUES ('320382', '320300', '邳州市');
INSERT INTO `fcm_areas` VALUES ('320401', '320400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320402', '320400', '天宁区');
INSERT INTO `fcm_areas` VALUES ('320404', '320400', '钟楼区');
INSERT INTO `fcm_areas` VALUES ('320405', '320400', '戚墅堰区');
INSERT INTO `fcm_areas` VALUES ('320411', '320400', '新北区');
INSERT INTO `fcm_areas` VALUES ('320412', '320400', '武进区');
INSERT INTO `fcm_areas` VALUES ('320481', '320400', '溧阳市');
INSERT INTO `fcm_areas` VALUES ('320482', '320400', '金坛市');
INSERT INTO `fcm_areas` VALUES ('320501', '320500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320502', '320500', '沧浪区');
INSERT INTO `fcm_areas` VALUES ('320503', '320500', '平江区');
INSERT INTO `fcm_areas` VALUES ('320504', '320500', '金阊区');
INSERT INTO `fcm_areas` VALUES ('320505', '320500', '虎丘区');
INSERT INTO `fcm_areas` VALUES ('320506', '320500', '吴中区');
INSERT INTO `fcm_areas` VALUES ('320507', '320500', '相城区');
INSERT INTO `fcm_areas` VALUES ('320581', '320500', '常熟市');
INSERT INTO `fcm_areas` VALUES ('320582', '320500', '张家港市');
INSERT INTO `fcm_areas` VALUES ('320583', '320500', '昆山市');
INSERT INTO `fcm_areas` VALUES ('320584', '320500', '吴江市');
INSERT INTO `fcm_areas` VALUES ('320585', '320500', '太仓市');
INSERT INTO `fcm_areas` VALUES ('320601', '320600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320602', '320600', '崇川区');
INSERT INTO `fcm_areas` VALUES ('320611', '320600', '港闸区');
INSERT INTO `fcm_areas` VALUES ('320621', '320600', '海安县');
INSERT INTO `fcm_areas` VALUES ('320623', '320600', '如东县');
INSERT INTO `fcm_areas` VALUES ('320681', '320600', '启东市');
INSERT INTO `fcm_areas` VALUES ('320682', '320600', '如皋市');
INSERT INTO `fcm_areas` VALUES ('320683', '320600', '通州市');
INSERT INTO `fcm_areas` VALUES ('320684', '320600', '海门市');
INSERT INTO `fcm_areas` VALUES ('320701', '320700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320703', '320700', '连云区');
INSERT INTO `fcm_areas` VALUES ('320705', '320700', '新浦区');
INSERT INTO `fcm_areas` VALUES ('320706', '320700', '海州区');
INSERT INTO `fcm_areas` VALUES ('320721', '320700', '赣榆县');
INSERT INTO `fcm_areas` VALUES ('320722', '320700', '东海县');
INSERT INTO `fcm_areas` VALUES ('320723', '320700', '灌云县');
INSERT INTO `fcm_areas` VALUES ('320724', '320700', '灌南县');
INSERT INTO `fcm_areas` VALUES ('320801', '320800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320802', '320800', '清河区');
INSERT INTO `fcm_areas` VALUES ('320803', '320800', '楚州区');
INSERT INTO `fcm_areas` VALUES ('320804', '320800', '淮阴区');
INSERT INTO `fcm_areas` VALUES ('320811', '320800', '清浦区');
INSERT INTO `fcm_areas` VALUES ('320826', '320800', '涟水县');
INSERT INTO `fcm_areas` VALUES ('320829', '320800', '洪泽县');
INSERT INTO `fcm_areas` VALUES ('320830', '320800', '盱眙县');
INSERT INTO `fcm_areas` VALUES ('320831', '320800', '金湖县');
INSERT INTO `fcm_areas` VALUES ('320901', '320900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('320902', '320900', '亭湖区');
INSERT INTO `fcm_areas` VALUES ('320903', '320900', '盐都区');
INSERT INTO `fcm_areas` VALUES ('320921', '320900', '响水县');
INSERT INTO `fcm_areas` VALUES ('320922', '320900', '滨海县');
INSERT INTO `fcm_areas` VALUES ('320923', '320900', '阜宁县');
INSERT INTO `fcm_areas` VALUES ('320924', '320900', '射阳县');
INSERT INTO `fcm_areas` VALUES ('320925', '320900', '建湖县');
INSERT INTO `fcm_areas` VALUES ('320981', '320900', '东台市');
INSERT INTO `fcm_areas` VALUES ('320982', '320900', '大丰市');
INSERT INTO `fcm_areas` VALUES ('321001', '321000', '市辖区');
INSERT INTO `fcm_areas` VALUES ('321002', '321000', '广陵区');
INSERT INTO `fcm_areas` VALUES ('321003', '321000', '邗江区');
INSERT INTO `fcm_areas` VALUES ('321011', '321000', '郊　区');
INSERT INTO `fcm_areas` VALUES ('321023', '321000', '宝应县');
INSERT INTO `fcm_areas` VALUES ('321081', '321000', '仪征市');
INSERT INTO `fcm_areas` VALUES ('321084', '321000', '高邮市');
INSERT INTO `fcm_areas` VALUES ('321088', '321000', '江都市');
INSERT INTO `fcm_areas` VALUES ('321101', '321100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('321102', '321100', '京口区');
INSERT INTO `fcm_areas` VALUES ('321111', '321100', '润州区');
INSERT INTO `fcm_areas` VALUES ('321112', '321100', '丹徒区');
INSERT INTO `fcm_areas` VALUES ('321181', '321100', '丹阳市');
INSERT INTO `fcm_areas` VALUES ('321182', '321100', '扬中市');
INSERT INTO `fcm_areas` VALUES ('321183', '321100', '句容市');
INSERT INTO `fcm_areas` VALUES ('321201', '321200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('321202', '321200', '海陵区');
INSERT INTO `fcm_areas` VALUES ('321203', '321200', '高港区');
INSERT INTO `fcm_areas` VALUES ('321281', '321200', '兴化市');
INSERT INTO `fcm_areas` VALUES ('321282', '321200', '靖江市');
INSERT INTO `fcm_areas` VALUES ('321283', '321200', '泰兴市');
INSERT INTO `fcm_areas` VALUES ('321284', '321200', '姜堰市');
INSERT INTO `fcm_areas` VALUES ('321301', '321300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('321302', '321300', '宿城区');
INSERT INTO `fcm_areas` VALUES ('321311', '321300', '宿豫区');
INSERT INTO `fcm_areas` VALUES ('321322', '321300', '沭阳县');
INSERT INTO `fcm_areas` VALUES ('321323', '321300', '泗阳县');
INSERT INTO `fcm_areas` VALUES ('321324', '321300', '泗洪县');
INSERT INTO `fcm_areas` VALUES ('330101', '330100', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330102', '330100', '上城区');
INSERT INTO `fcm_areas` VALUES ('330103', '330100', '下城区');
INSERT INTO `fcm_areas` VALUES ('330104', '330100', '江干区');
INSERT INTO `fcm_areas` VALUES ('330105', '330100', '拱墅区');
INSERT INTO `fcm_areas` VALUES ('330106', '330100', '西湖区');
INSERT INTO `fcm_areas` VALUES ('330108', '330100', '滨江区');
INSERT INTO `fcm_areas` VALUES ('330109', '330100', '萧山区');
INSERT INTO `fcm_areas` VALUES ('330110', '330100', '余杭区');
INSERT INTO `fcm_areas` VALUES ('330122', '330100', '桐庐县');
INSERT INTO `fcm_areas` VALUES ('330127', '330100', '淳安县');
INSERT INTO `fcm_areas` VALUES ('330182', '330100', '建德市');
INSERT INTO `fcm_areas` VALUES ('330183', '330100', '富阳市');
INSERT INTO `fcm_areas` VALUES ('330185', '330100', '临安市');
INSERT INTO `fcm_areas` VALUES ('330201', '330200', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330203', '330200', '海曙区');
INSERT INTO `fcm_areas` VALUES ('330204', '330200', '江东区');
INSERT INTO `fcm_areas` VALUES ('330205', '330200', '江北区');
INSERT INTO `fcm_areas` VALUES ('330206', '330200', '北仑区');
INSERT INTO `fcm_areas` VALUES ('330211', '330200', '镇海区');
INSERT INTO `fcm_areas` VALUES ('330212', '330200', '鄞州区');
INSERT INTO `fcm_areas` VALUES ('330225', '330200', '象山县');
INSERT INTO `fcm_areas` VALUES ('330226', '330200', '宁海县');
INSERT INTO `fcm_areas` VALUES ('330281', '330200', '余姚市');
INSERT INTO `fcm_areas` VALUES ('330282', '330200', '慈溪市');
INSERT INTO `fcm_areas` VALUES ('330283', '330200', '奉化市');
INSERT INTO `fcm_areas` VALUES ('330301', '330300', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330302', '330300', '鹿城区');
INSERT INTO `fcm_areas` VALUES ('330303', '330300', '龙湾区');
INSERT INTO `fcm_areas` VALUES ('330304', '330300', '瓯海区');
INSERT INTO `fcm_areas` VALUES ('330322', '330300', '洞头县');
INSERT INTO `fcm_areas` VALUES ('330324', '330300', '永嘉县');
INSERT INTO `fcm_areas` VALUES ('330326', '330300', '平阳县');
INSERT INTO `fcm_areas` VALUES ('330327', '330300', '苍南县');
INSERT INTO `fcm_areas` VALUES ('330328', '330300', '文成县');
INSERT INTO `fcm_areas` VALUES ('330329', '330300', '泰顺县');
INSERT INTO `fcm_areas` VALUES ('330381', '330300', '瑞安市');
INSERT INTO `fcm_areas` VALUES ('330382', '330300', '乐清市');
INSERT INTO `fcm_areas` VALUES ('330401', '330400', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330402', '330400', '秀城区');
INSERT INTO `fcm_areas` VALUES ('330411', '330400', '秀洲区');
INSERT INTO `fcm_areas` VALUES ('330421', '330400', '嘉善县');
INSERT INTO `fcm_areas` VALUES ('330424', '330400', '海盐县');
INSERT INTO `fcm_areas` VALUES ('330481', '330400', '海宁市');
INSERT INTO `fcm_areas` VALUES ('330482', '330400', '平湖市');
INSERT INTO `fcm_areas` VALUES ('330483', '330400', '桐乡市');
INSERT INTO `fcm_areas` VALUES ('330501', '330500', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330502', '330500', '吴兴区');
INSERT INTO `fcm_areas` VALUES ('330503', '330500', '南浔区');
INSERT INTO `fcm_areas` VALUES ('330521', '330500', '德清县');
INSERT INTO `fcm_areas` VALUES ('330522', '330500', '长兴县');
INSERT INTO `fcm_areas` VALUES ('330523', '330500', '安吉县');
INSERT INTO `fcm_areas` VALUES ('330601', '330600', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330602', '330600', '越城区');
INSERT INTO `fcm_areas` VALUES ('330621', '330600', '绍兴县');
INSERT INTO `fcm_areas` VALUES ('330624', '330600', '新昌县');
INSERT INTO `fcm_areas` VALUES ('330681', '330600', '诸暨市');
INSERT INTO `fcm_areas` VALUES ('330682', '330600', '上虞市');
INSERT INTO `fcm_areas` VALUES ('330683', '330600', '嵊州市');
INSERT INTO `fcm_areas` VALUES ('330701', '330700', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330702', '330700', '婺城区');
INSERT INTO `fcm_areas` VALUES ('330703', '330700', '金东区');
INSERT INTO `fcm_areas` VALUES ('330723', '330700', '武义县');
INSERT INTO `fcm_areas` VALUES ('330726', '330700', '浦江县');
INSERT INTO `fcm_areas` VALUES ('330727', '330700', '磐安县');
INSERT INTO `fcm_areas` VALUES ('330781', '330700', '兰溪市');
INSERT INTO `fcm_areas` VALUES ('330782', '330700', '义乌市');
INSERT INTO `fcm_areas` VALUES ('330783', '330700', '东阳市');
INSERT INTO `fcm_areas` VALUES ('330784', '330700', '永康市');
INSERT INTO `fcm_areas` VALUES ('330801', '330800', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330802', '330800', '柯城区');
INSERT INTO `fcm_areas` VALUES ('330803', '330800', '衢江区');
INSERT INTO `fcm_areas` VALUES ('330822', '330800', '常山县');
INSERT INTO `fcm_areas` VALUES ('330824', '330800', '开化县');
INSERT INTO `fcm_areas` VALUES ('330825', '330800', '龙游县');
INSERT INTO `fcm_areas` VALUES ('330881', '330800', '江山市');
INSERT INTO `fcm_areas` VALUES ('330901', '330900', '市辖区');
INSERT INTO `fcm_areas` VALUES ('330902', '330900', '定海区');
INSERT INTO `fcm_areas` VALUES ('330903', '330900', '普陀区');
INSERT INTO `fcm_areas` VALUES ('330921', '330900', '岱山县');
COMMIT;

-- ----------------------------
-- Table structure for fcm_business
-- ----------------------------
DROP TABLE IF EXISTS `fcm_business`;
CREATE TABLE `fcm_business` (
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `name` varchar(20) NOT NULL COMMENT '真实姓名',
  `state` tinyint(1) NOT NULL COMMENT '登录状态 0、正常登录 1、禁止登录',
  `type` tinyint(1) NOT NULL COMMENT '身份类型 0、老板 1、店长 2、店员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`,`store_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家身份表';

-- ----------------------------
-- Table structure for fcm_cities
-- ----------------------------
DROP TABLE IF EXISTS `fcm_cities`;
CREATE TABLE `fcm_cities` (
  `city_id` varchar(6) CHARACTER SET utf8 NOT NULL COMMENT '城市编码',
  `province_id` varchar(6) CHARACTER SET utf8 NOT NULL COMMENT '所属省份编码',
  `city` varchar(40) CHARACTER SET utf8 NOT NULL COMMENT '城市名称',
  PRIMARY KEY (`city_id`) USING BTREE,
  UNIQUE KEY `unx_province_id_and_city_id` (`province_id`,`city_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='城市信息表';

-- ----------------------------
-- Records of fcm_cities
-- ----------------------------
BEGIN;
INSERT INTO `fcm_cities` VALUES ('110100', '110000', '北京市');
INSERT INTO `fcm_cities` VALUES ('1102xx', '1100xx', '北京下属县');
INSERT INTO `fcm_cities` VALUES ('120100', '120000', '天津市');
INSERT INTO `fcm_cities` VALUES ('1202xx', '1200xx', '天津下属县');
INSERT INTO `fcm_cities` VALUES ('130100', '130000', '石家庄市');
INSERT INTO `fcm_cities` VALUES ('130200', '130000', '唐山市');
INSERT INTO `fcm_cities` VALUES ('130300', '130000', '秦皇岛市');
INSERT INTO `fcm_cities` VALUES ('130400', '130000', '邯郸市');
INSERT INTO `fcm_cities` VALUES ('130500', '130000', '邢台市');
INSERT INTO `fcm_cities` VALUES ('130600', '130000', '保定市');
INSERT INTO `fcm_cities` VALUES ('130700', '130000', '张家口市');
INSERT INTO `fcm_cities` VALUES ('130800', '130000', '承德市');
INSERT INTO `fcm_cities` VALUES ('130900', '130000', '沧州市');
INSERT INTO `fcm_cities` VALUES ('131000', '130000', '廊坊市');
INSERT INTO `fcm_cities` VALUES ('131100', '130000', '衡水市');
INSERT INTO `fcm_cities` VALUES ('140100', '140000', '太原市');
INSERT INTO `fcm_cities` VALUES ('140200', '140000', '大同市');
INSERT INTO `fcm_cities` VALUES ('140300', '140000', '阳泉市');
INSERT INTO `fcm_cities` VALUES ('140400', '140000', '长治市');
INSERT INTO `fcm_cities` VALUES ('140500', '140000', '晋城市');
INSERT INTO `fcm_cities` VALUES ('140600', '140000', '朔州市');
INSERT INTO `fcm_cities` VALUES ('140700', '140000', '晋中市');
INSERT INTO `fcm_cities` VALUES ('140800', '140000', '运城市');
INSERT INTO `fcm_cities` VALUES ('140900', '140000', '忻州市');
INSERT INTO `fcm_cities` VALUES ('141000', '140000', '临汾市');
INSERT INTO `fcm_cities` VALUES ('141100', '140000', '吕梁市');
INSERT INTO `fcm_cities` VALUES ('150100', '150000', '呼和浩特市');
INSERT INTO `fcm_cities` VALUES ('150200', '150000', '包头市');
INSERT INTO `fcm_cities` VALUES ('150300', '150000', '乌海市');
INSERT INTO `fcm_cities` VALUES ('150400', '150000', '赤峰市');
INSERT INTO `fcm_cities` VALUES ('150500', '150000', '通辽市');
INSERT INTO `fcm_cities` VALUES ('150600', '150000', '鄂尔多斯市');
INSERT INTO `fcm_cities` VALUES ('150700', '150000', '呼伦贝尔市');
INSERT INTO `fcm_cities` VALUES ('150800', '150000', '巴彦淖尔市');
INSERT INTO `fcm_cities` VALUES ('150900', '150000', '乌兰察布市');
INSERT INTO `fcm_cities` VALUES ('152200', '150000', '兴安盟');
INSERT INTO `fcm_cities` VALUES ('152500', '150000', '锡林郭勒盟');
INSERT INTO `fcm_cities` VALUES ('152900', '150000', '阿拉善盟');
INSERT INTO `fcm_cities` VALUES ('210100', '210000', '沈阳市');
INSERT INTO `fcm_cities` VALUES ('210200', '210000', '大连市');
INSERT INTO `fcm_cities` VALUES ('210300', '210000', '鞍山市');
INSERT INTO `fcm_cities` VALUES ('210400', '210000', '抚顺市');
INSERT INTO `fcm_cities` VALUES ('210500', '210000', '本溪市');
INSERT INTO `fcm_cities` VALUES ('210600', '210000', '丹东市');
INSERT INTO `fcm_cities` VALUES ('210700', '210000', '锦州市');
INSERT INTO `fcm_cities` VALUES ('210800', '210000', '营口市');
INSERT INTO `fcm_cities` VALUES ('210900', '210000', '阜新市');
INSERT INTO `fcm_cities` VALUES ('211000', '210000', '辽阳市');
INSERT INTO `fcm_cities` VALUES ('211100', '210000', '盘锦市');
INSERT INTO `fcm_cities` VALUES ('211200', '210000', '铁岭市');
INSERT INTO `fcm_cities` VALUES ('211300', '210000', '朝阳市');
INSERT INTO `fcm_cities` VALUES ('211400', '210000', '葫芦岛市');
INSERT INTO `fcm_cities` VALUES ('220100', '220000', '长春市');
INSERT INTO `fcm_cities` VALUES ('220200', '220000', '吉林市');
INSERT INTO `fcm_cities` VALUES ('220300', '220000', '四平市');
INSERT INTO `fcm_cities` VALUES ('220400', '220000', '辽源市');
INSERT INTO `fcm_cities` VALUES ('220500', '220000', '通化市');
INSERT INTO `fcm_cities` VALUES ('220600', '220000', '白山市');
INSERT INTO `fcm_cities` VALUES ('220700', '220000', '松原市');
INSERT INTO `fcm_cities` VALUES ('220800', '220000', '白城市');
INSERT INTO `fcm_cities` VALUES ('222400', '220000', '延边朝鲜族自治州');
INSERT INTO `fcm_cities` VALUES ('230100', '230000', '哈尔滨市');
INSERT INTO `fcm_cities` VALUES ('230200', '230000', '齐齐哈尔市');
INSERT INTO `fcm_cities` VALUES ('230300', '230000', '鸡西市');
INSERT INTO `fcm_cities` VALUES ('230400', '230000', '鹤岗市');
INSERT INTO `fcm_cities` VALUES ('230500', '230000', '双鸭山市');
INSERT INTO `fcm_cities` VALUES ('230600', '230000', '大庆市');
INSERT INTO `fcm_cities` VALUES ('230700', '230000', '伊春市');
INSERT INTO `fcm_cities` VALUES ('230800', '230000', '佳木斯市');
INSERT INTO `fcm_cities` VALUES ('230900', '230000', '七台河市');
INSERT INTO `fcm_cities` VALUES ('231000', '230000', '牡丹江市');
INSERT INTO `fcm_cities` VALUES ('231100', '230000', '黑河市');
INSERT INTO `fcm_cities` VALUES ('231200', '230000', '绥化市');
INSERT INTO `fcm_cities` VALUES ('232700', '230000', '大兴安岭地区');
INSERT INTO `fcm_cities` VALUES ('310100', '310000', '上海市');
INSERT INTO `fcm_cities` VALUES ('3102xx', '3100xx', '上海下属县');
INSERT INTO `fcm_cities` VALUES ('320100', '320000', '南京市');
INSERT INTO `fcm_cities` VALUES ('320200', '320000', '无锡市');
INSERT INTO `fcm_cities` VALUES ('320300', '320000', '徐州市');
INSERT INTO `fcm_cities` VALUES ('320400', '320000', '常州市');
INSERT INTO `fcm_cities` VALUES ('320500', '320000', '苏州市');
INSERT INTO `fcm_cities` VALUES ('320600', '320000', '南通市');
INSERT INTO `fcm_cities` VALUES ('320700', '320000', '连云港市');
INSERT INTO `fcm_cities` VALUES ('320800', '320000', '淮安市');
INSERT INTO `fcm_cities` VALUES ('320900', '320000', '盐城市');
INSERT INTO `fcm_cities` VALUES ('321000', '320000', '扬州市');
INSERT INTO `fcm_cities` VALUES ('321100', '320000', '镇江市');
INSERT INTO `fcm_cities` VALUES ('321200', '320000', '泰州市');
INSERT INTO `fcm_cities` VALUES ('321300', '320000', '宿迁市');
INSERT INTO `fcm_cities` VALUES ('330100', '330000', '杭州市');
INSERT INTO `fcm_cities` VALUES ('330200', '330000', '宁波市');
INSERT INTO `fcm_cities` VALUES ('330300', '330000', '温州市');
INSERT INTO `fcm_cities` VALUES ('330400', '330000', '嘉兴市');
INSERT INTO `fcm_cities` VALUES ('330500', '330000', '湖州市');
INSERT INTO `fcm_cities` VALUES ('330600', '330000', '绍兴市');
INSERT INTO `fcm_cities` VALUES ('330700', '330000', '金华市');
INSERT INTO `fcm_cities` VALUES ('330800', '330000', '衢州市');
INSERT INTO `fcm_cities` VALUES ('330900', '330000', '舟山市');
INSERT INTO `fcm_cities` VALUES ('331000', '330000', '台州市');
INSERT INTO `fcm_cities` VALUES ('331100', '330000', '丽水市');
INSERT INTO `fcm_cities` VALUES ('340100', '340000', '合肥市');
INSERT INTO `fcm_cities` VALUES ('340200', '340000', '芜湖市');
INSERT INTO `fcm_cities` VALUES ('340300', '340000', '蚌埠市');
INSERT INTO `fcm_cities` VALUES ('340400', '340000', '淮南市');
INSERT INTO `fcm_cities` VALUES ('340500', '340000', '马鞍山市');
INSERT INTO `fcm_cities` VALUES ('340600', '340000', '淮北市');
INSERT INTO `fcm_cities` VALUES ('340700', '340000', '铜陵市');
INSERT INTO `fcm_cities` VALUES ('340800', '340000', '安庆市');
INSERT INTO `fcm_cities` VALUES ('341000', '340000', '黄山市');
INSERT INTO `fcm_cities` VALUES ('341100', '340000', '滁州市');
INSERT INTO `fcm_cities` VALUES ('341200', '340000', '阜阳市');
INSERT INTO `fcm_cities` VALUES ('341300', '340000', '宿州市');
INSERT INTO `fcm_cities` VALUES ('341400', '340000', '巢湖市');
INSERT INTO `fcm_cities` VALUES ('341500', '340000', '六安市');
INSERT INTO `fcm_cities` VALUES ('341600', '340000', '亳州市');
INSERT INTO `fcm_cities` VALUES ('341700', '340000', '池州市');
INSERT INTO `fcm_cities` VALUES ('341800', '340000', '宣城市');
INSERT INTO `fcm_cities` VALUES ('350100', '350000', '福州市');
INSERT INTO `fcm_cities` VALUES ('350200', '350000', '厦门市');
INSERT INTO `fcm_cities` VALUES ('350300', '350000', '莆田市');
INSERT INTO `fcm_cities` VALUES ('350400', '350000', '三明市');
INSERT INTO `fcm_cities` VALUES ('350500', '350000', '泉州市');
INSERT INTO `fcm_cities` VALUES ('350600', '350000', '漳州市');
INSERT INTO `fcm_cities` VALUES ('350700', '350000', '南平市');
INSERT INTO `fcm_cities` VALUES ('350800', '350000', '龙岩市');
INSERT INTO `fcm_cities` VALUES ('350900', '350000', '宁德市');
INSERT INTO `fcm_cities` VALUES ('360100', '360000', '南昌市');
INSERT INTO `fcm_cities` VALUES ('360200', '360000', '景德镇市');
INSERT INTO `fcm_cities` VALUES ('360300', '360000', '萍乡市');
INSERT INTO `fcm_cities` VALUES ('360400', '360000', '九江市');
INSERT INTO `fcm_cities` VALUES ('360500', '360000', '新余市');
INSERT INTO `fcm_cities` VALUES ('360600', '360000', '鹰潭市');
INSERT INTO `fcm_cities` VALUES ('360700', '360000', '赣州市');
INSERT INTO `fcm_cities` VALUES ('360800', '360000', '吉安市');
INSERT INTO `fcm_cities` VALUES ('360900', '360000', '宜春市');
INSERT INTO `fcm_cities` VALUES ('361000', '360000', '抚州市');
INSERT INTO `fcm_cities` VALUES ('361100', '360000', '上饶市');
INSERT INTO `fcm_cities` VALUES ('370100', '370000', '济南市');
INSERT INTO `fcm_cities` VALUES ('370200', '370000', '青岛市');
INSERT INTO `fcm_cities` VALUES ('370300', '370000', '淄博市');
INSERT INTO `fcm_cities` VALUES ('370400', '370000', '枣庄市');
INSERT INTO `fcm_cities` VALUES ('370500', '370000', '东营市');
INSERT INTO `fcm_cities` VALUES ('370600', '370000', '烟台市');
INSERT INTO `fcm_cities` VALUES ('370700', '370000', '潍坊市');
INSERT INTO `fcm_cities` VALUES ('370800', '370000', '济宁市');
INSERT INTO `fcm_cities` VALUES ('370900', '370000', '泰安市');
INSERT INTO `fcm_cities` VALUES ('371000', '370000', '威海市');
INSERT INTO `fcm_cities` VALUES ('371100', '370000', '日照市');
INSERT INTO `fcm_cities` VALUES ('371200', '370000', '莱芜市');
INSERT INTO `fcm_cities` VALUES ('371300', '370000', '临沂市');
INSERT INTO `fcm_cities` VALUES ('371400', '370000', '德州市');
INSERT INTO `fcm_cities` VALUES ('371500', '370000', '聊城市');
INSERT INTO `fcm_cities` VALUES ('371600', '370000', '滨州市');
INSERT INTO `fcm_cities` VALUES ('371700', '370000', '荷泽市');
INSERT INTO `fcm_cities` VALUES ('410100', '410000', '郑州市');
INSERT INTO `fcm_cities` VALUES ('410200', '410000', '开封市');
INSERT INTO `fcm_cities` VALUES ('410300', '410000', '洛阳市');
INSERT INTO `fcm_cities` VALUES ('410400', '410000', '平顶山市');
INSERT INTO `fcm_cities` VALUES ('410500', '410000', '安阳市');
INSERT INTO `fcm_cities` VALUES ('410600', '410000', '鹤壁市');
INSERT INTO `fcm_cities` VALUES ('410700', '410000', '新乡市');
INSERT INTO `fcm_cities` VALUES ('410800', '410000', '焦作市');
INSERT INTO `fcm_cities` VALUES ('410900', '410000', '濮阳市');
INSERT INTO `fcm_cities` VALUES ('411000', '410000', '许昌市');
INSERT INTO `fcm_cities` VALUES ('411100', '410000', '漯河市');
INSERT INTO `fcm_cities` VALUES ('411200', '410000', '三门峡市');
INSERT INTO `fcm_cities` VALUES ('411300', '410000', '南阳市');
INSERT INTO `fcm_cities` VALUES ('411400', '410000', '商丘市');
INSERT INTO `fcm_cities` VALUES ('411500', '410000', '信阳市');
INSERT INTO `fcm_cities` VALUES ('411600', '410000', '周口市');
INSERT INTO `fcm_cities` VALUES ('411700', '410000', '驻马店市');
INSERT INTO `fcm_cities` VALUES ('420100', '420000', '武汉市');
INSERT INTO `fcm_cities` VALUES ('420200', '420000', '黄石市');
INSERT INTO `fcm_cities` VALUES ('420300', '420000', '十堰市');
INSERT INTO `fcm_cities` VALUES ('420500', '420000', '宜昌市');
INSERT INTO `fcm_cities` VALUES ('420600', '420000', '襄樊市');
INSERT INTO `fcm_cities` VALUES ('420700', '420000', '鄂州市');
INSERT INTO `fcm_cities` VALUES ('420800', '420000', '荆门市');
INSERT INTO `fcm_cities` VALUES ('420900', '420000', '孝感市');
INSERT INTO `fcm_cities` VALUES ('421000', '420000', '荆州市');
INSERT INTO `fcm_cities` VALUES ('421100', '420000', '黄冈市');
INSERT INTO `fcm_cities` VALUES ('421200', '420000', '咸宁市');
INSERT INTO `fcm_cities` VALUES ('421300', '420000', '随州市');
INSERT INTO `fcm_cities` VALUES ('422800', '420000', '恩施土家族苗族自治州');
INSERT INTO `fcm_cities` VALUES ('429000', '420000', '省直辖行政单位');
INSERT INTO `fcm_cities` VALUES ('430100', '430000', '长沙市');
INSERT INTO `fcm_cities` VALUES ('430200', '430000', '株洲市');
INSERT INTO `fcm_cities` VALUES ('430300', '430000', '湘潭市');
INSERT INTO `fcm_cities` VALUES ('430400', '430000', '衡阳市');
INSERT INTO `fcm_cities` VALUES ('430500', '430000', '邵阳市');
INSERT INTO `fcm_cities` VALUES ('430600', '430000', '岳阳市');
INSERT INTO `fcm_cities` VALUES ('430700', '430000', '常德市');
INSERT INTO `fcm_cities` VALUES ('430800', '430000', '张家界市');
INSERT INTO `fcm_cities` VALUES ('430900', '430000', '益阳市');
INSERT INTO `fcm_cities` VALUES ('431000', '430000', '郴州市');
INSERT INTO `fcm_cities` VALUES ('431100', '430000', '永州市');
INSERT INTO `fcm_cities` VALUES ('431200', '430000', '怀化市');
INSERT INTO `fcm_cities` VALUES ('431300', '430000', '娄底市');
INSERT INTO `fcm_cities` VALUES ('433100', '430000', '湘西土家族苗族自治州');
INSERT INTO `fcm_cities` VALUES ('440100', '440000', '广州市');
INSERT INTO `fcm_cities` VALUES ('440200', '440000', '韶关市');
INSERT INTO `fcm_cities` VALUES ('440300', '440000', '深圳市');
INSERT INTO `fcm_cities` VALUES ('440400', '440000', '珠海市');
INSERT INTO `fcm_cities` VALUES ('440500', '440000', '汕头市');
INSERT INTO `fcm_cities` VALUES ('440600', '440000', '佛山市');
INSERT INTO `fcm_cities` VALUES ('440700', '440000', '江门市');
INSERT INTO `fcm_cities` VALUES ('440800', '440000', '湛江市');
INSERT INTO `fcm_cities` VALUES ('440900', '440000', '茂名市');
INSERT INTO `fcm_cities` VALUES ('441200', '440000', '肇庆市');
INSERT INTO `fcm_cities` VALUES ('441300', '440000', '惠州市');
INSERT INTO `fcm_cities` VALUES ('441400', '440000', '梅州市');
INSERT INTO `fcm_cities` VALUES ('441500', '440000', '汕尾市');
INSERT INTO `fcm_cities` VALUES ('441600', '440000', '河源市');
INSERT INTO `fcm_cities` VALUES ('441700', '440000', '阳江市');
INSERT INTO `fcm_cities` VALUES ('441800', '440000', '清远市');
INSERT INTO `fcm_cities` VALUES ('441900', '440000', '东莞市');
INSERT INTO `fcm_cities` VALUES ('442000', '440000', '中山市');
INSERT INTO `fcm_cities` VALUES ('445100', '440000', '潮州市');
INSERT INTO `fcm_cities` VALUES ('445200', '440000', '揭阳市');
INSERT INTO `fcm_cities` VALUES ('445300', '440000', '云浮市');
INSERT INTO `fcm_cities` VALUES ('450100', '450000', '南宁市');
INSERT INTO `fcm_cities` VALUES ('450200', '450000', '柳州市');
INSERT INTO `fcm_cities` VALUES ('450300', '450000', '桂林市');
INSERT INTO `fcm_cities` VALUES ('450400', '450000', '梧州市');
INSERT INTO `fcm_cities` VALUES ('450500', '450000', '北海市');
INSERT INTO `fcm_cities` VALUES ('450600', '450000', '防城港市');
INSERT INTO `fcm_cities` VALUES ('450700', '450000', '钦州市');
INSERT INTO `fcm_cities` VALUES ('450800', '450000', '贵港市');
INSERT INTO `fcm_cities` VALUES ('450900', '450000', '玉林市');
INSERT INTO `fcm_cities` VALUES ('451000', '450000', '百色市');
INSERT INTO `fcm_cities` VALUES ('451100', '450000', '贺州市');
INSERT INTO `fcm_cities` VALUES ('451200', '450000', '河池市');
INSERT INTO `fcm_cities` VALUES ('451300', '450000', '来宾市');
INSERT INTO `fcm_cities` VALUES ('451400', '450000', '崇左市');
INSERT INTO `fcm_cities` VALUES ('460100', '460000', '海口市');
INSERT INTO `fcm_cities` VALUES ('460200', '460000', '三亚市');
INSERT INTO `fcm_cities` VALUES ('469000', '460000', '省直辖县级行政单位');
INSERT INTO `fcm_cities` VALUES ('500100', '500000', '重庆市');
INSERT INTO `fcm_cities` VALUES ('5002xx', '5000xx', '重庆下属县');
INSERT INTO `fcm_cities` VALUES ('5003xx', '5000xx', '重庆下属市');
INSERT INTO `fcm_cities` VALUES ('510100', '510000', '成都市');
INSERT INTO `fcm_cities` VALUES ('510300', '510000', '自贡市');
INSERT INTO `fcm_cities` VALUES ('510400', '510000', '攀枝花市');
INSERT INTO `fcm_cities` VALUES ('510500', '510000', '泸州市');
INSERT INTO `fcm_cities` VALUES ('510600', '510000', '德阳市');
INSERT INTO `fcm_cities` VALUES ('510700', '510000', '绵阳市');
INSERT INTO `fcm_cities` VALUES ('510800', '510000', '广元市');
INSERT INTO `fcm_cities` VALUES ('510900', '510000', '遂宁市');
INSERT INTO `fcm_cities` VALUES ('511000', '510000', '内江市');
INSERT INTO `fcm_cities` VALUES ('511100', '510000', '乐山市');
INSERT INTO `fcm_cities` VALUES ('511300', '510000', '南充市');
INSERT INTO `fcm_cities` VALUES ('511400', '510000', '眉山市');
INSERT INTO `fcm_cities` VALUES ('511500', '510000', '宜宾市');
INSERT INTO `fcm_cities` VALUES ('511600', '510000', '广安市');
INSERT INTO `fcm_cities` VALUES ('511700', '510000', '达州市');
INSERT INTO `fcm_cities` VALUES ('511800', '510000', '雅安市');
INSERT INTO `fcm_cities` VALUES ('511900', '510000', '巴中市');
INSERT INTO `fcm_cities` VALUES ('512000', '510000', '资阳市');
INSERT INTO `fcm_cities` VALUES ('513200', '510000', '阿坝藏族羌族自治州');
INSERT INTO `fcm_cities` VALUES ('513300', '510000', '甘孜藏族自治州');
INSERT INTO `fcm_cities` VALUES ('513400', '510000', '凉山彝族自治州');
INSERT INTO `fcm_cities` VALUES ('520100', '520000', '贵阳市');
INSERT INTO `fcm_cities` VALUES ('520200', '520000', '六盘水市');
INSERT INTO `fcm_cities` VALUES ('520300', '520000', '遵义市');
INSERT INTO `fcm_cities` VALUES ('520400', '520000', '安顺市');
INSERT INTO `fcm_cities` VALUES ('522200', '520000', '铜仁地区');
INSERT INTO `fcm_cities` VALUES ('522300', '520000', '黔西南布依族苗族自治州');
INSERT INTO `fcm_cities` VALUES ('522400', '520000', '毕节地区');
INSERT INTO `fcm_cities` VALUES ('522600', '520000', '黔东南苗族侗族自治州');
INSERT INTO `fcm_cities` VALUES ('522700', '520000', '黔南布依族苗族自治州');
INSERT INTO `fcm_cities` VALUES ('530100', '530000', '昆明市');
INSERT INTO `fcm_cities` VALUES ('530300', '530000', '曲靖市');
INSERT INTO `fcm_cities` VALUES ('530400', '530000', '玉溪市');
INSERT INTO `fcm_cities` VALUES ('530500', '530000', '保山市');
INSERT INTO `fcm_cities` VALUES ('530600', '530000', '昭通市');
INSERT INTO `fcm_cities` VALUES ('530700', '530000', '丽江市');
INSERT INTO `fcm_cities` VALUES ('530800', '530000', '思茅市');
INSERT INTO `fcm_cities` VALUES ('530900', '530000', '临沧市');
INSERT INTO `fcm_cities` VALUES ('532300', '530000', '楚雄彝族自治州');
INSERT INTO `fcm_cities` VALUES ('532500', '530000', '红河哈尼族彝族自治州');
INSERT INTO `fcm_cities` VALUES ('532600', '530000', '文山壮族苗族自治州');
INSERT INTO `fcm_cities` VALUES ('532800', '530000', '西双版纳傣族自治州');
INSERT INTO `fcm_cities` VALUES ('532900', '530000', '大理白族自治州');
INSERT INTO `fcm_cities` VALUES ('533100', '530000', '德宏傣族景颇族自治州');
INSERT INTO `fcm_cities` VALUES ('533300', '530000', '怒江傈僳族自治州');
INSERT INTO `fcm_cities` VALUES ('533400', '530000', '迪庆藏族自治州');
INSERT INTO `fcm_cities` VALUES ('540100', '540000', '拉萨市');
INSERT INTO `fcm_cities` VALUES ('542100', '540000', '昌都地区');
INSERT INTO `fcm_cities` VALUES ('542200', '540000', '山南地区');
INSERT INTO `fcm_cities` VALUES ('542300', '540000', '日喀则地区');
INSERT INTO `fcm_cities` VALUES ('542400', '540000', '那曲地区');
INSERT INTO `fcm_cities` VALUES ('542500', '540000', '阿里地区');
INSERT INTO `fcm_cities` VALUES ('542600', '540000', '林芝地区');
INSERT INTO `fcm_cities` VALUES ('610100', '610000', '西安市');
INSERT INTO `fcm_cities` VALUES ('610200', '610000', '铜川市');
INSERT INTO `fcm_cities` VALUES ('610300', '610000', '宝鸡市');
INSERT INTO `fcm_cities` VALUES ('610400', '610000', '咸阳市');
INSERT INTO `fcm_cities` VALUES ('610500', '610000', '渭南市');
INSERT INTO `fcm_cities` VALUES ('610600', '610000', '延安市');
INSERT INTO `fcm_cities` VALUES ('610700', '610000', '汉中市');
INSERT INTO `fcm_cities` VALUES ('610800', '610000', '榆林市');
INSERT INTO `fcm_cities` VALUES ('610900', '610000', '安康市');
INSERT INTO `fcm_cities` VALUES ('611000', '610000', '商洛市');
INSERT INTO `fcm_cities` VALUES ('620100', '620000', '兰州市');
INSERT INTO `fcm_cities` VALUES ('620200', '620000', '嘉峪关市');
INSERT INTO `fcm_cities` VALUES ('620300', '620000', '金昌市');
INSERT INTO `fcm_cities` VALUES ('620400', '620000', '白银市');
INSERT INTO `fcm_cities` VALUES ('620500', '620000', '天水市');
INSERT INTO `fcm_cities` VALUES ('620600', '620000', '武威市');
INSERT INTO `fcm_cities` VALUES ('620700', '620000', '张掖市');
INSERT INTO `fcm_cities` VALUES ('620800', '620000', '平凉市');
INSERT INTO `fcm_cities` VALUES ('620900', '620000', '酒泉市');
INSERT INTO `fcm_cities` VALUES ('621000', '620000', '庆阳市');
INSERT INTO `fcm_cities` VALUES ('621100', '620000', '定西市');
INSERT INTO `fcm_cities` VALUES ('621200', '620000', '陇南市');
INSERT INTO `fcm_cities` VALUES ('622900', '620000', '临夏回族自治州');
INSERT INTO `fcm_cities` VALUES ('623000', '620000', '甘南藏族自治州');
INSERT INTO `fcm_cities` VALUES ('630100', '630000', '西宁市');
INSERT INTO `fcm_cities` VALUES ('632100', '630000', '海东地区');
INSERT INTO `fcm_cities` VALUES ('632200', '630000', '海北藏族自治州');
INSERT INTO `fcm_cities` VALUES ('632300', '630000', '黄南藏族自治州');
INSERT INTO `fcm_cities` VALUES ('632500', '630000', '海南藏族自治州');
INSERT INTO `fcm_cities` VALUES ('632600', '630000', '果洛藏族自治州');
INSERT INTO `fcm_cities` VALUES ('632700', '630000', '玉树藏族自治州');
INSERT INTO `fcm_cities` VALUES ('632800', '630000', '海西蒙古族藏族自治州');
INSERT INTO `fcm_cities` VALUES ('640100', '640000', '银川市');
INSERT INTO `fcm_cities` VALUES ('640200', '640000', '石嘴山市');
INSERT INTO `fcm_cities` VALUES ('640300', '640000', '吴忠市');
INSERT INTO `fcm_cities` VALUES ('640400', '640000', '固原市');
INSERT INTO `fcm_cities` VALUES ('640500', '640000', '中卫市');
INSERT INTO `fcm_cities` VALUES ('650100', '650000', '乌鲁木齐市');
INSERT INTO `fcm_cities` VALUES ('650200', '650000', '克拉玛依市');
INSERT INTO `fcm_cities` VALUES ('652100', '650000', '吐鲁番地区');
INSERT INTO `fcm_cities` VALUES ('652200', '650000', '哈密地区');
INSERT INTO `fcm_cities` VALUES ('652300', '650000', '昌吉回族自治州');
INSERT INTO `fcm_cities` VALUES ('652700', '650000', '博尔塔拉蒙古自治州');
INSERT INTO `fcm_cities` VALUES ('652800', '650000', '巴音郭楞蒙古自治州');
INSERT INTO `fcm_cities` VALUES ('652900', '650000', '阿克苏地区');
INSERT INTO `fcm_cities` VALUES ('653000', '650000', '克孜勒苏柯尔克孜自治州');
INSERT INTO `fcm_cities` VALUES ('653100', '650000', '喀什地区');
INSERT INTO `fcm_cities` VALUES ('653200', '650000', '和田地区');
INSERT INTO `fcm_cities` VALUES ('654000', '650000', '伊犁哈萨克自治州');
INSERT INTO `fcm_cities` VALUES ('654200', '650000', '塔城地区');
INSERT INTO `fcm_cities` VALUES ('654300', '650000', '阿勒泰地区');
INSERT INTO `fcm_cities` VALUES ('659000', '650000', '省直辖行政单位');
COMMIT;

-- ----------------------------
-- Table structure for fcm_fraction_proportion
-- ----------------------------
DROP TABLE IF EXISTS `fcm_fraction_proportion`;
CREATE TABLE `fcm_fraction_proportion` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '赠送积分比例唯一标识',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `user_id` bigint(20) NOT NULL COMMENT '操作人的用户id',
  `goods_id` tinyint(1) NOT NULL DEFAULT '0' COMMENT '默认值为0（表示全部商品，后期通过商品id判断赠送积分比例)目前暂时无作用',
  `fraction_proportion` decimal(4,2) NOT NULL DEFAULT '0.01' COMMENT '积分比例（0.01~1）',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unx_store_id_and_goods_id` (`store_id`,`goods_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='赠送积分比例表';

-- ----------------------------
-- Table structure for fcm_operation_type
-- ----------------------------
DROP TABLE IF EXISTS `fcm_operation_type`;
CREATE TABLE `fcm_operation_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '操作类型唯一标识',
  `name` varchar(45) NOT NULL COMMENT '类型名称',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='操作类型表';

-- ----------------------------
-- Table structure for fcm_place
-- ----------------------------
DROP TABLE IF EXISTS `fcm_place`;
CREATE TABLE `fcm_place` (
  `place_id` varchar(6) NOT NULL COMMENT '小区表的唯一标识',
  `area_id` varchar(6) NOT NULL COMMENT '地区表id',
  `place` varchar(45) NOT NULL COMMENT '小区名字',
  `address` varchar(255) NOT NULL COMMENT '小区地址',
  PRIMARY KEY (`place_id`) USING BTREE,
  UNIQUE KEY `unx_area_id_and_place_id` (`area_id`,`place_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小区信息表';

-- ----------------------------
-- Table structure for fcm_provinces
-- ----------------------------
DROP TABLE IF EXISTS `fcm_provinces`;
CREATE TABLE `fcm_provinces` (
  `province_id` varchar(6) CHARACTER SET utf8 NOT NULL,
  `province` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`province_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='省级信息表';

-- ----------------------------
-- Records of fcm_provinces
-- ----------------------------
BEGIN;
INSERT INTO `fcm_provinces` VALUES ('110000', '北京市');
INSERT INTO `fcm_provinces` VALUES ('120000', '天津市');
INSERT INTO `fcm_provinces` VALUES ('130000', '河北省');
INSERT INTO `fcm_provinces` VALUES ('140000', '山西省');
INSERT INTO `fcm_provinces` VALUES ('150000', '内蒙古自治区');
INSERT INTO `fcm_provinces` VALUES ('210000', '辽宁省');
INSERT INTO `fcm_provinces` VALUES ('220000', '吉林省');
INSERT INTO `fcm_provinces` VALUES ('230000', '黑龙江省');
INSERT INTO `fcm_provinces` VALUES ('310000', '上海市');
INSERT INTO `fcm_provinces` VALUES ('320000', '江苏省');
INSERT INTO `fcm_provinces` VALUES ('330000', '浙江省');
INSERT INTO `fcm_provinces` VALUES ('340000', '安徽省');
INSERT INTO `fcm_provinces` VALUES ('350000', '福建省');
INSERT INTO `fcm_provinces` VALUES ('360000', '江西省');
INSERT INTO `fcm_provinces` VALUES ('370000', '山东省');
INSERT INTO `fcm_provinces` VALUES ('410000', '河南省');
INSERT INTO `fcm_provinces` VALUES ('420000', '湖北省');
INSERT INTO `fcm_provinces` VALUES ('430000', '湖南省');
INSERT INTO `fcm_provinces` VALUES ('440000', '广东省');
INSERT INTO `fcm_provinces` VALUES ('450000', '广西壮族自治区');
INSERT INTO `fcm_provinces` VALUES ('460000', '海南省');
INSERT INTO `fcm_provinces` VALUES ('500000', '重庆市');
INSERT INTO `fcm_provinces` VALUES ('510000', '四川省');
INSERT INTO `fcm_provinces` VALUES ('520000', '贵州省');
INSERT INTO `fcm_provinces` VALUES ('530000', '云南省');
INSERT INTO `fcm_provinces` VALUES ('540000', '西藏自治区');
INSERT INTO `fcm_provinces` VALUES ('610000', '陕西省');
INSERT INTO `fcm_provinces` VALUES ('620000', '甘肃省');
INSERT INTO `fcm_provinces` VALUES ('630000', '青海省');
INSERT INTO `fcm_provinces` VALUES ('640000', '宁夏回族自治区');
INSERT INTO `fcm_provinces` VALUES ('650000', '新疆维吾尔自治区');
INSERT INTO `fcm_provinces` VALUES ('710000', '台湾省');
INSERT INTO `fcm_provinces` VALUES ('810000', '香港特别行政区');
INSERT INTO `fcm_provinces` VALUES ('820000', '澳门特别行政区');
COMMIT;

-- ----------------------------
-- Table structure for fcm_store
-- ----------------------------
DROP TABLE IF EXISTS `fcm_store`;
CREATE TABLE `fcm_store` (
  `id` bigint(20) NOT NULL COMMENT '门店id',
  `user_id` bigint(20) NOT NULL COMMENT '老板的用户id',
  `place_id` char(6) NOT NULL COMMENT '所在小区（初期版本，由人工审核，人工设定）',
  `store_type_id` bigint(20) NOT NULL COMMENT '门店类型id',
  `store_name` varchar(45) NOT NULL COMMENT '门店名称',
  `image` varchar(255) NOT NULL COMMENT '门店首图',
  `phone` varchar(20) NOT NULL COMMENT '店铺电话',
  `license` varchar(255) NOT NULL COMMENT '营业执照存储路径',
  `turnover` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '收益金额',
  `refund` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额',
  `give_fraction` bigint(20) NOT NULL DEFAULT '0' COMMENT '已赠积分',
  `surplus_fraction` bigint(20) NOT NULL DEFAULT '0' COMMENT '积分余额',
  `introduce` varchar(255) NOT NULL COMMENT '商家简介',
  `address` varchar(255) NOT NULL COMMENT '所在地址',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '营业状态 0、营业中 1、未营业 ',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许商家设置比例 0、允许 1、不允许',
  `type` tinyint(1) NOT NULL COMMENT '商家状态 0、待审核 1、审核通过 2、审核失败',
  `create_time` datetime NOT NULL COMMENT '入驻时间',
  `latitude` double NOT NULL COMMENT '纬度，范围为-90~90，负数表示南纬。使用 gcj02 国测局坐标系',
  `longitude` double NOT NULL COMMENT '经度，范围为-180~180，负数表示西经。使用 gcj02 国测局坐标系',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店信息表';

-- ----------------------------
-- Table structure for fcm_store_fans
-- ----------------------------
DROP TABLE IF EXISTS `fcm_store_fans`;
CREATE TABLE `fcm_store_fans` (
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`store_id`,`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店粉丝表（以消费者的第一笔支付为准，进行永久绑定）';

-- ----------------------------
-- Table structure for fcm_store_fraction
-- ----------------------------
DROP TABLE IF EXISTS `fcm_store_fraction`;
CREATE TABLE `fcm_store_fraction` (
  `order_number` varchar(64) NOT NULL COMMENT '商家积分明细唯一标识',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `user_id` bigint(20) NOT NULL COMMENT '店员用户id',
  `money` decimal(10,2) NOT NULL COMMENT '金额',
  `fraction` bigint(20) NOT NULL COMMENT '积分',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '金额状态 0、未付款 1、已付款 2、未打款 3、已打款',
  `type` tinyint(1) NOT NULL COMMENT '积分状态 0、钱换积分 1、积分换钱',
  `create_time` datetime NOT NULL COMMENT '购买时间',
  PRIMARY KEY (`order_number`) USING BTREE,
  KEY `idx_store_id` (`store_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店积分明细表';

-- ----------------------------
-- Table structure for fcm_store_info
-- ----------------------------
DROP TABLE IF EXISTS `fcm_store_info`;
CREATE TABLE `fcm_store_info` (
  `id` bigint(20) NOT NULL,
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `message` varchar(255) NOT NULL COMMENT '信息',
  `type` tinyint(1) NOT NULL COMMENT '类型 0、不现实 1、图片 2、文字',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店铺详细信息表';

-- ----------------------------
-- Table structure for fcm_store_operation
-- ----------------------------
DROP TABLE IF EXISTS `fcm_store_operation`;
CREATE TABLE `fcm_store_operation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商家操作日志表的唯一标识',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `user_id` bigint(20) NOT NULL COMMENT '店员id',
  `operation_id` bigint(20) NOT NULL COMMENT '操作表类型id',
  `description` varchar(255) NOT NULL COMMENT '描述',
  `create_time` datetime NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_store_id_and_user_id` (`store_id`,`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COMMENT='门店操作日志表';

-- ----------------------------
-- Table structure for fcm_store_type
-- ----------------------------
DROP TABLE IF EXISTS `fcm_store_type`;
CREATE TABLE `fcm_store_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商家类型唯一标识',
  `name` varchar(45) NOT NULL COMMENT '类型名称',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店类型表';

-- ----------------------------
-- Table structure for fcm_user
-- ----------------------------
DROP TABLE IF EXISTS `fcm_user`;
CREATE TABLE `fcm_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户的唯一标识',
  `m_openid` varchar(200) NOT NULL COMMENT '小程序openid',
  `wx_openid` varchar(200) DEFAULT NULL COMMENT '服务号openid',
  `unionid` varchar(200) DEFAULT NULL COMMENT '微信unionid',
  `nickname` varchar(45) DEFAULT NULL COMMENT '用户昵称',
  `faceimage` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `money` decimal(10,2) NOT NULL COMMENT '余额',
  `fraction` bigint(20) NOT NULL COMMENT '积分',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '登录状态  0、正常登录 1、禁止登录',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '激活状态 0、未激活  1、已激活 ',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户身份 0、普通用户 1、商家   2、管理员 3、超级管理员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `unx_m_openid` (`m_openid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';

-- ----------------------------
-- Table structure for fcm_user_consumption
-- ----------------------------
DROP TABLE IF EXISTS `fcm_user_consumption`;
CREATE TABLE `fcm_user_consumption` (
  `order_number` varchar(64) NOT NULL COMMENT '订单号',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `store_user_id` bigint(20) NOT NULL COMMENT '店员id',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `price` decimal(10,2) NOT NULL COMMENT '消费金额',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消费明细状态 (0、未完成 1、已完成 2、退款申请中  3、已退款 4、已失效)',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消费类型 （0、线上消费 1、线下消费)',
  `create_time` datetime NOT NULL COMMENT '订单生成时间',
  `complete_time` datetime DEFAULT NULL COMMENT '订单完成时间',
  `apply_time` datetime DEFAULT NULL COMMENT '退款申请时间',
  `refund_time` datetime DEFAULT NULL COMMENT '退款完成时间',
  `form_id` varchar(200) DEFAULT NULL COMMENT '用于用户通知的form_id',
  PRIMARY KEY (`order_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户消费明细表';

-- ----------------------------
-- Table structure for fcm_user_fraction
-- ----------------------------
DROP TABLE IF EXISTS `fcm_user_fraction`;
CREATE TABLE `fcm_user_fraction` (
  `order_number` varchar(64) NOT NULL COMMENT '订单号',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `store_id` bigint(20) NOT NULL COMMENT '门店id',
  `fraction` bigint(20) NOT NULL DEFAULT '0' COMMENT '积分',
  `state` tinyint(1) NOT NULL COMMENT '(用户的角度)积分状态 0、收入 1、支出 / (店铺的角度)积分状态 1、收入 0、支出',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`order_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户积分明细表';

-- ----------------------------
-- Table structure for fcm_user_recharges
-- ----------------------------
DROP TABLE IF EXISTS `fcm_user_recharges`;
CREATE TABLE `fcm_user_recharges` (
  `order_number` varchar(64) NOT NULL COMMENT '充值记录明细唯一标识',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `store_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '门店id (默认0，表示无商家充值)',
  `store_user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '店员id (默认0，表示无商家充值)',
  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
  `state` tinyint(1) NOT NULL COMMENT '充值状态  0、未充值 1、充值中 2、充值成功 3、充值失败',
  `type` tinyint(1) NOT NULL COMMENT '充值类型 0、线上充值 1、商家充值 2、管理员充值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `recharge_time` datetime DEFAULT NULL COMMENT '充值成功时间',
  `appid` varchar(200) DEFAULT NULL COMMENT '微信充值的appid',
  `prepay_id` varchar(200) DEFAULT NULL COMMENT 'prepay_id用于做微信消息模版回调',
  `time_stamp` varchar(20) DEFAULT NULL COMMENT '微信支付时间',
  PRIMARY KEY (`order_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户充值记录表';

-- ----------------------------
-- Table structure for wx_app_info
-- ----------------------------
DROP TABLE IF EXISTS `wx_app_info`;
CREATE TABLE `wx_app_info` (
  `app_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '应用appid,微信分配',
  `app_secret` varchar(300) COLLATE utf8_unicode_ci NOT NULL COMMENT '应用appsecret,微信分配',
  `msg_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '消息验证token',
  `msg_key` varchar(100) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '消息验证key',
  `msgdataformat` varchar(20) COLLATE utf8_unicode_ci DEFAULT 'JSON' COMMENT '消息格式，XML或者JSON',
  `login_duration` int(11) NOT NULL DEFAULT '30' COMMENT '登录过期时间，单位为天，默认 30 天，判断微信session_key',
  `session_duration` int(11) NOT NULL DEFAULT '2592000' COMMENT '会话过期时间，单位为秒，默认为 2592000 秒(即30天)，判断实际业务会话过期设置',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='微信应用信息管理表';

-- ----------------------------
-- Records of wx_app_info
-- ----------------------------
BEGIN;
INSERT INTO `wx_app_info` VALUES ('wx4cbc5f4c0db9937e', 'c2241c8d8bf835745d296534cba5d763', '', '', 'JSON', 30, 2592000, '2019-03-06 21:00:13', '2019-03-06 21:00:15', '家旁小程序');
COMMIT;

-- ----------------------------
-- Table structure for wx_app_pay
-- ----------------------------
DROP TABLE IF EXISTS `wx_app_pay`;
CREATE TABLE `wx_app_pay` (
  `app_id` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '应用appid,微信分配',
  `mch_id` varchar(300) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '微信支付商户号',
  `mch_key` varchar(300) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '微信支付商户密钥',
  `sub_app_id` varchar(300) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '服务商模式下的子商户公众账号ID，普通模式请不要配置，请在配置文件中将对应项删除',
  `sub_mch_id` varchar(300) COLLATE utf8_unicode_ci DEFAULT '' COMMENT '服务商模式下的子商户号，普通模式请不要配置，最好是请在配置文件中将对应项删除',
  `key_path` varchar(300) COLLATE utf8_unicode_ci DEFAULT '' COMMENT 'apiclient_cert.p12文件的绝对路径，或者如果放在项目中，请以classpath:开头指定',
  `notify_url` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '通知地址',
  `trade_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'JSAPI' COMMENT '交易类型',
  `sign_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT 'MD5' COMMENT '签名类型',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='微信应用信息管理表';

-- ----------------------------
-- Records of wx_app_pay
-- ----------------------------
BEGIN;
INSERT INTO `wx_app_pay` VALUES ('wx4cbc5f4c0db9937e', '1353955902', 'JIAPANGshenghuo2019WEIXINPAY5key', '', '', '', 'https://www.jia-pang.cn/miniapp/wx/pay/notify/order', 'JSAPI', 'MD5', '2019-05-15 15:28:54', '2019-05-15 15:28:58', '家旁小程序');
COMMIT;

-- ----------------------------
-- Table structure for wx_form_message
-- ----------------------------
DROP TABLE IF EXISTS `wx_form_message`;
CREATE TABLE `wx_form_message` (
  `id` bigint(20) NOT NULL,
  `formid` varchar(200) NOT NULL COMMENT 'fromid',
  `touserid` varchar(200) NOT NULL COMMENT 'touserid',
  `setTemplateId` varchar(200) NOT NULL COMMENT 'templateid',
  `data` varchar(255) NOT NULL COMMENT '数据',
  `create_time` datetime NOT NULL COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='发送消息记录表';

-- ----------------------------
-- Table structure for wx_notify_template
-- ----------------------------
DROP TABLE IF EXISTS `wx_notify_template`;
CREATE TABLE `wx_notify_template` (
  `id` varchar(45) NOT NULL COMMENT '通知模版id',
  `title` varchar(45) NOT NULL COMMENT '通知模版标题',
  `number` bigint(1) NOT NULL DEFAULT '1' COMMENT '携带参数（1～9）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unx_title` (`title`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信通知模版类型';

-- ----------------------------
-- Table structure for wx_notify_user
-- ----------------------------
DROP TABLE IF EXISTS `wx_notify_user`;
CREATE TABLE `wx_notify_user` (
  `id` bigint(20) NOT NULL COMMENT '消息id',
  `template_id` varchar(45) DEFAULT NULL COMMENT '模板标题id',
  `template_title` varchar(45) DEFAULT NULL COMMENT '模板标题内容',
  `to_user_openid` varchar(200) DEFAULT NULL COMMENT '被通知用户的openid',
  `method` varchar(255) DEFAULT NULL COMMENT '通知方式（例如：手机通知）',
  `frequency` int(11) DEFAULT NULL COMMENT '通知次数（例如：每通知一次数+1）',
  `state` tinyint(1) DEFAULT NULL COMMENT '通知状态 （0、成功 1、失败）',
  `mini_program_appid` varchar(200) DEFAULT NULL COMMENT '所需跳转到的小程序appid（该小程序appid必须与发模板消息的公众号是绑定关联关系，暂不支持小游戏）',
  `mini_program_page_path` varchar(255) DEFAULT NULL COMMENT '所需跳转到小程序的具体页面路径，支持带参数,（示例index?foo=bar），暂不支持小游戏'',',
  `create_people` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `message_type` varchar(200) DEFAULT NULL COMMENT '消息类型(解释扩展字段代表着什么)',
  `field1` varchar(200) DEFAULT NULL COMMENT '扩展字段1',
  `field2` varchar(200) DEFAULT NULL COMMENT '扩展字段2',
  `field3` varchar(200) DEFAULT NULL COMMENT '扩展字段3',
  `field4` varchar(200) DEFAULT NULL COMMENT '扩展字段4',
  `field5` varchar(200) DEFAULT NULL COMMENT '扩展字段5',
  `field6` varchar(200) DEFAULT NULL COMMENT '扩展字段6',
  `field7` varchar(200) DEFAULT NULL COMMENT '扩展字段7',
  `field8` varchar(200) DEFAULT NULL COMMENT '扩展字段8',
  `field9` varchar(200) DEFAULT NULL COMMENT '扩展字段9',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消费通知记录表';

-- ----------------------------
-- Table structure for wx_pay_notify
-- ----------------------------
DROP TABLE IF EXISTS `wx_pay_notify`;
CREATE TABLE `wx_pay_notify` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(200) DEFAULT NULL COMMENT '微信分配的小程序ID',
  `bank_type` varchar(200) DEFAULT NULL COMMENT '银行类型，采用字符串类型的银行标识，银行类型见银行列表',
  `fee_type` varchar(200) DEFAULT NULL COMMENT '货币类型，符合ISO4217标准的三位字母代码，默认人民币：CNY，其他值列表详见货币类型',
  `is_subscribe` varchar(200) DEFAULT NULL COMMENT '用户是否关注公众账号，Y-关注，N-未关注',
  `mch_id` varchar(200) DEFAULT NULL COMMENT '微信支付分配的商户号',
  `openid` varchar(200) DEFAULT NULL COMMENT '用户在商户appid下的唯一标识',
  `out_trade_no` varchar(200) DEFAULT NULL COMMENT '商户系统内部订单号，要求32个字符内，只能是数字、大小写字母_-|*@ ，且在同一个商户号下唯一。',
  `result_code` varchar(200) DEFAULT NULL COMMENT 'SUCCESS/FAIL',
  `return_code` varchar(200) DEFAULT NULL COMMENT 'SUCCESS/FAIL',
  `time_end` varchar(200) DEFAULT NULL COMMENT '支付完成时间，格式为yyyyMMddHHmmss，如2009年12月25日9点10分10秒表示为20091225091010。其他详见时间规则',
  `total_fee` int(200) DEFAULT NULL COMMENT '订单总金额，单位为分',
  `trade_type` varchar(200) DEFAULT NULL COMMENT 'JSAPI、NATIVE、APP',
  `transaction_id` varchar(200) DEFAULT NULL COMMENT '微信支付订单号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COMMENT='微信支付成功后回调参数记录表';

SET FOREIGN_KEY_CHECKS = 1;
